Microsoft Office Tutorials and References
In Depth Information
To Goal Seek
2
•
Click Goal Seek to
display the Goal Seek
dialog box with the
Set cell box set to the
selected cell, H16.
cell on which
to seek goal is
set based on
active cell
•
When Excel displays
the Goal Seek dialog
box, click the To
value text box, type
10,500,000
and
then click the By
changing cell box.
Goal Seek
dialog box
•
Scroll down so row 4
is at the top of
the screen.
goal
•
Click cell B25 on the
worksheet to assign
cell B25 to the By
changing cell box
(Figure 3–80).
cell to change
to reach goal
OK button
active cell
Figure 3–80
