• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Goal Seeking

Use Goal Seeking to force a particular result in a calculation by changing one of its components. For example, if you know how much you can afford for a monthly payment on a loan, you can use Goal Seeking to find the down payment necessary to produce that monthly payment.

To set the result of a calculation and find a contributing value:

1.
Confirm that the value you want to find is part of the formula that calculates the value you want to set (Figure 14.13).

Figure 14.13. Make sure the value you want to find is part of the formula.


2.
Choose Tools > Goal Seek (Figure 14.14).

Figure 14.14. Choose Tools > Goal Seek.


3.
In the Goal Seek dialog box, specify the cell whose value you want to set (Monthly Payment, in our example), the value you want that cell to be, and the cell whose value can vary to make the result come out to the value you want (Down Payment) (Figure 14.15). Click OK.

Figure 14.15. Specify the Goal Seek parameters.


4.
If a solution is possible, the Goal Seek Status dialog box (Figure 14.16) will tell you, and the cell you selected to change will change (Figure 14.17).

Figure 14.16. Results appear in Goal Seek Status.


Figure 14.17. The cell in the sheet changes.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint