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
 
Search JabSto ::




Custom Search