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

Seeking Goals

Use goal seeking to force a particular result in a calculation by changing one of the calculation’s components. For example, if you know the percentage growth you are looking for, you can use Goal Seeking to determine the changes that would be necessary to produce that result.

To seek a goal:

1.
From the Tools menu, choose Goal Seek.

2.
In the Goal Seek dialog box, specify the cell whose value you want to set (this should be a cell whose value is usually calculated through a formula), the value you want that cell to have, and the cell whose value can vary to make the result come out to the value you want (Figure 16.21).

Figure 16.21. Specify the cell to set, the value, and the cell to change in the Goal Seek dialog box.


3.
Click OK.

If a solution is possible, the Goal Seek Status dialog will tell you, and the variable cell you specified will change.

4.
Click OK to accept the change or click Cancel to reject it (Figure 16.22).

Figure 16.22. The result of the goal seeking.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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