Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours

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 ...