When you know the desired result of a single formula, but not the values the formula needs for the result, you can use the Goal Seek feature. For example, you can afford a $1,800 monthly payment, so how much of a loan can you take out? When goal seeking, Excel plugs different values into a cell until it finds one that works.

### Use Goal Seek

- Click the
**Data**tab on the ribbon. - Click the
**What-If Analysis**button. - Select
**Goal Seek**. - Select the cell with the formula where you want to define the result.
- Click in the
**To value**field. - Type the desired result of the formula.
- Click in the
**By changing cell**field. - Select the cell you want to change to reach the desired result.
- Click
**OK**. - Click
**OK**to confirm replacing the original worksheet values.

The Goal Seek dialog box appears.

This cell must be a cell that is referenced by the formula.

Excel recalculates the formula and displays the value needed to achieve the formula result you desire in the worksheet.

Clicking **Cancel** closes the dialog box and restores the original worksheet values.

Excel replaces the original values and the desired result is calculated.