Microsoft Office Tutorials and References
In Depth Information
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
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
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
goal in a cell