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