Microsoft Office Tutorials and References
In Depth Information
Goal Seeking
3. Click the What-If Analysis icon in the Data Tools group.
A pull-down menu appears, as shown in Figure 9-14.
4. Click Goal Seek.
The Goal Seek dialog box appears, as shown in Figure 9-15.
5. Click in the To Value text box and type a number that you want
to appear in the formula stored in the cell that you clicked in
Step 1.
6. Click in the By Changing Cell text box and click one cell that contains
data used by the formula you chose in Step 1.
Excel displays your cell reference, such as B5, in the Goal Seek
dialog box.
7. Click OK.
The Goal Seek Status dialog box changes the data in the cell you chose
in Step 6, as shown in Figure 9-16.
8. Click OK (to keep the changes) or click Cancel (to display the
original values your spreadsheet had before you chose the Goal
Seek command).
Figure 9-14:
The What-If
Analysis
icon
displays the
Goal Seek
command.
Figure 9-15:
Define your
goal in a cell
containing a
formula.
 
Search JabSto ::




Custom Search