Chapter 18. The Goal Seek Command

Questions answered in this chapter:

  • For a given price, how many glasses of lemonade does a lemonade store need to sell per year to break even?

  • We want to pay off our mortgage in 15 years. The annual interest rate is 6 percent. The bank told us we can afford monthly payments of $2,000. How much can we borrow?

  • I always had trouble with “story problems” in high school algebra. Can Excel make solving story problems easier?

The Goal Seek feature in Microsoft Excel 2010 enables you to compute a value for a worksheet input that makes the value of a given formula match the goal you specify. For example, in the lemonade store example in Chapter 17, suppose you have fixed overhead costs, fixed per-unit costs, and a fixed sales ...

Get Microsoft® Excel® 2010: Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.