Asking What If with Goal Seek

Asking "What If" with Goal Seek

graphics/microsoft46.gif

Excel's powerful functions make it easy to create powerful formulas, such as calculating payments over time. Sometimes, however, being able to make these calculations is only half the battle. Your formula might tell you that a monthly payment amount is $2,000, while you might only be able to manage a $1,750 payment. Goal Seek enables you to work backwards to a desired result, or goal, by adjusting the input values.

Create a "What-If" Scenario with Goal Seek

graphics/one_icon.jpg

Click any cell within the list range.

graphics/tow_icon.jpg

Click the Tools menu, and then click Goal Seek.

graphics/three_icon.jpg Click the Set Cell box, and then type the cell address you want to change.

You can also click the Collapse Dialog button, use your mouse to select the cells , and then click the Expand Dialog button.

graphics/foure_icon.jpg

Click the To Value box, and then type the result value.

graphics/five_icon.jpg Click the By Changing Cell box, and then type the cell address you want Excel to change.

You can also click the Collapse Dialog button, use your mouse to select the cells, and then click the Expand Dialog button.

graphics/six_icon.jpg

Click OK.

graphics/11inf07.jpg



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com Ā© 2008-2017.
If you may any questions please contact us: flylib@qtcs.net