Microsoft Office Tutorials and References
In Depth Information
EX 226
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
2
Click Goal Seek to
display the Goal Seek
dialog box with the
Set cell box set to the
selected cell, H16.
Goal Seek
dialog box
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
10500000 and then
click the By changing
cell box.
goal
OK button
Scroll down so row 4
is at the top of
the screen.
cell to change
to reach goal
Click cell B25 on the
worksheet to assign
cell B25 to the By
changing cell box
(Figure 3–80).
active cell
Figure 3–80
Search JabSto ::




Custom Search