O'Reilly logo

Microsoft® Excel® 2010 Inside Out by Mark Dodge and Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using the Goal Seek Command

By clicking the What-If Analysis button on the Data tab and then clicking Goal Seek, you can compute an unknown value that produces the result you want. For example, suppose you want to know the maximum 30-year mortgage you can afford if the interest rate is 6.5 percent and if you must limit your monthly payments to $2,000. To use the Goal Seek command to answer this question, first set up the problem using trial values. For example, in the mortgage problem shown in Figure 18-19, a $500,000 mortgage would require monthly payments in excess of the $2,000 target.

Use the Goal Seek command to find the maximum mortgage you can borrow if you want to keep your payments under a certain limit.

Figure 18-19. Use the Goal Seek command to find the maximum ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required