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

Goal Seeking

You 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 use goal seeking

1.
Choose Tools > Goal Seek.

2.
In the Goal Seek dialog box (Figure 15.8), enter the following:

  • Set cell. The cell whose value you want to set (Monthly Payment or E2, in this example).

  • To value. The value you want the Set cell to become ($900, in this example).

  • By changing cell. The cell whose value will change in order to make the Set cell result (E2) equal the To value ($900). In this example, the By changing cell is Down Payment (B2).

Figure 15.8. Type or point to values and cell addresses to fill in the Goal Seek text boxes.


3.
Click OK to perform the calculation.

The Goal Seek Status dialog box appears (Figure 15.9) and displays the result. The By changing cell is altered, as specified.

Figure 15.9. The Goal Seek Status dialog box indicates whether a solution was found. If so, the worksheet is changed as specified.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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