• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Building More Powerful Worksheets > Asking “What If” with Goal Seek

Asking “What If” with Goal Seek

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint