![]() Suppose that you have a bank account that gives you a 4% annual interest on the money you have in your account. However, to use Goal Seek to its full potential, you need to have a proper formula in place, to begin with.įor this example, let's take a small banking case. Goal Seek can be useful when you utilize it in real-life scenarios. Click OK to have Goal Seek work its magic.Finally, in the By changing cell, select the cell you want to change to reach the goal.For this example, we want our average to be 26, so the goal value will be 26 as well. In To value, insert the goal value you want.Having highlighted C1 before opening the Goal Seek window will automatically set it in Set cell. In the Goal Seek window, set the Set cell to C1.Under the Data tab, select What-If Analysis and then Goal Seek.Select cell C1, and then from the ribbon, go to the Data tab.For this example, change the value of the A1 cell to 16. ![]() You can make sure your formula works by inputting numbers in A1 and B1. In the formula bar, enter the following code: =AVERAGE(A1:B1) This formula will have Excel calculate the average of the values in cells A1 and B1 and output that in cell C1.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |