O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

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 Tool

Goal Seek is a useful tool that you can use to achieve a certain value in a cell that contains a formula. The way you do that is to adjust the value of another cell that has a direct effect on the original cell. If I can afford $400 a month, what could I borrow? You can use Goal Seek to see how much you can borrow to make the payment of $500 per month.

How the Goal Seek Tool Works

The following To Do exercise shows you how Goal Seek works. You need to enter data on Sheet2 in the Data Analysis workbook to prepare for using Goal Seek.

To Do: Use the Goal Seek Tool
1.
In Sheet2, type the data shown in the worksheet in Figure 17.8. For the worksheet to look just like the one in the figure, left-align cells C6:C9 and format ...

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