Using Goal Seek in Excel 2007

Goal Seek allows you to resolve a problem when you know the target result by changing a value in a specific cell that directly affects the formula.  Suppose you want to obtain a home loan but can only afford $800 a month.  With Goal Seek, you could determine the maximum home purchase price that you could afford.

You must provide three parameters for Goal Seek:

1. The cell you want to change.  In the example above, this would be the loan amount.
2. The value to which you want to change the target cell.  In the example above, this would be $800.
3. The cell you want to change to achieve the target amount.  In the example above, this would be the price of the home.

To Use Goal Seek

1. Click the Data tab on the Ribbon.
2. Click the What-if Analysis button and click Goal Seek from the menu.
3. In the Set Cell Box, type the cell reference of the cell that contains the formula you want to change.
4. In the To Value box, type in the value to which you want to change the cell. 
5. In the By changing cell box, enter the cell reference of the cell that contains the value you want to adjust.
6. Click OK.
7. Click OK.

Similar Posts:

None Found

Tagged as: Excel 2007 Tips, Goal Seek, Microsoft Office Tips