Goal Seek

 

Goal Seek Example 1 | Goal Seek Example 2

If you know the result you want from a formula, use Goal Seek in Excel to find the input value that produces this formula result.

Goal Seek Example 1

Use Goal Seek in Excel to find the grade on the fourth exam that produces a final grade of 70.

1. The formula in cell B7 calculates the final grade.

Formula Result

2. The grade on the fourth exam in cell B5 is the input cell.

Input Cell

3. On the Data tab, in the Forecast group, click What-If Analysis.

Click What-If Analysis

4. Click Goal Seek.

Click Goal Seek

The Goal Seek dialog box appears.

5. Select cell B7.

6. Click in the 'To value' box and type 70.

7. Click in the 'By changing cell' box and select cell B5.

8. Click OK.

Goal Seek Parameters

Result. A grade of 90 on the fourth exam produces a final grade of 70.

Goal Seek Solution

Goal Seek Example 2

Use Goal Seek in Excel to find the loan amount that produces a monthly payment of $1500.

1. The formula in cell B5 calculates the monthly payment.

PMT function

Explanation: the PMT function calculates the payment for a loan. If you've never heard of this function before, that's OK. The higher the loan amount, the higher the monthly payment. Assume, you can only afford $1500 a month. What is your maximum loan amount?

2. The loan amount in cell B3 is the input cell.

Loan Amount

3. On the Data tab, in the Forecast group, click What-If Analysis.

Click What-If Analysis

4. Click Goal Seek.

Click Goal Seek

The Goal Seek dialog box appears.

5. Select cell B5.

6. Click in the 'To value' box and type -1500 (negative, you are paying out money).

7. Click in the 'By changing cell' box and select cell B3.

8. Click OK.

Goal Seek Variables

Result. A loan amount of $250,187 produces a monthly payment of $1500.

Goal Seek Found a Solution

3/4 Completed! Learn more about what-if analysis >
Go to Next Chapter: Solver   |   Become an Excel Pro: 300 Examples