Goal Seek in Excel: How to Find and Use It Step by Step

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, find Goal Seek by selecting Data > What-If Analysis > Goal Seek (in the Forecast group on the ribbon). It works backward from a result you want to find the input value that produces it. Before opening it, make sure your worksheet has a formula for the result and a separate input cell Excel can change.

What You’ll Need

  • A desktop version of Excel with the workbook open. Goal Seek is available in Excel for Microsoft 365 on Windows and Mac, but not in Excel for the web. If you are in a browser, open the workbook in the desktop app.
  • A formula cell containing the result you want to reach, such as revenue, a payment, or a percentage.
  • One input cell that affects the formula result. Goal Seek changes one cell at a time.
  • A clear target value, plus a saved copy or a note of the starting input if you need to preserve it.

Step-by-Step

  1. Prepare a simple model. Put the input you want to adjust in one cell and calculate the result in another. For example, enter a unit price of 25 in B2 and a quantity of 120 in B3. With the unit price in B2 and quantity in B3, enter this formula in B4: =B2*B3. B4 calculates revenue, which is 25 multiplied by 120, or 3,000. The result cell must contain a formula, not a value typed in by hand.
  2. Choose the result cell. Click the worksheet cell that contains the formula you want to make reach a target. In the example, select B4. You can select a different cell before opening Goal Seek, but checking the selected cell helps you confirm you are working with the intended calculation. If the formula depends on other cells, make sure those references point to the inputs you expect.
  3. Open Goal Seek from the ribbon. Select the Data tab, then choose What-If Analysis and Goal Seek. On the standard Windows ribbon, What-If Analysis is in the Forecast group. If the button is not immediately visible, check that you are on the Data tab and look within that group. In Excel for Mac, use Data > What-If Analysis > Goal Seek; ribbon arrangement can vary slightly by window size.
  4. Check the Set cell field. The Goal Seek dialog has three fields. In Set cell, enter or select the formula cell whose result should meet your target. For the example, use B4. You can click the small worksheet-selection button beside a field, select the cell, and press Enter to return to the dialog. Make sure this field points to the formula result, not to the input you want Excel to change.
  5. Enter the target in To value. Type the number you want the formula cell to return. For example, enter 3600 to ask Excel to find a unit price that produces revenue of 3,600. Enter a numeric value without typing an equals sign. For percentages, use the underlying decimal value: a target of 10% is 0.1 when the cell is formatted as a percentage. Confirm the target uses the same units as the formula result.
  6. Identify the input in By changing cell. Enter the one cell Excel is allowed to adjust. In the example, use B2, the unit price. Do not put B4 here: the changing cell should be an input, not the result formula. It must be a cell that the formula in Set cell depends on, either directly or through other formulas. If changing the selected input cannot affect the result, Goal Seek cannot reach the target.
  7. Run the calculation. Review all three fields, then click OK. Excel tries different values in the changing cell and recalculates the result until it reaches the target or gets as close as it can. In the example, B2 should become 30, because 30 multiplied by 120 equals 3,600. The result in B4 should then display 3,600. If Excel reports that it could not find a solution, see the troubleshooting section below.
  8. Keep or reject the result. Excel displays a status message and leaves the Goal Seek result in the worksheet while the dialog is open. Choose OK to keep the calculated input or Cancel to restore the previous value. After keeping it, check the changing cell and result cell, and confirm the rest of the model still makes sense. Goal Seek changes the worksheet input; it does not create a separate report of the answer.

Common Mistakes

  • Putting a constant in Set cell. Goal Seek needs a formula whose output can change. If you select a cell containing a typed number, Excel has no calculation to work backward through. Put the calculation in a cell first, then set that formula cell as the goal.
  • Choosing the wrong changing cell. The selected input has to influence the result. If the formula references B2 but you ask Excel to change an unrelated cell, the result will not move. Trace the formula references or test whether changing the input manually changes the result.
  • Expecting Goal Seek to change several inputs. Goal Seek adjusts one variable cell per run. It does not let you set constraints such as requiring an input to be a whole number or remain above a minimum. For multiple changing variables or constraints, use Solver if it is available in your Excel setup.
  • Entering a target in the wrong scale. A formatted percentage may display 10% while its stored value is 0.1. Likewise, a result in thousands of dollars is not the same as a result in dollars. Check the cell format and units before entering To value.
  • Assuming the first answer is the only possible answer. In a nonlinear model, multiple inputs might produce the same result. Goal Seek uses the current value as a starting point, so it may find one solution and not another. Review whether the answer is sensible for your model.

Tips

  • Save the starting value. Write down the original input or duplicate the worksheet before running Goal Seek if you want an easy comparison. This is especially useful when trying several targets because accepting a result changes the input used in the next run.
  • Use clear labels. Label the input, formula result, and units near the cells. For example, identify B2 as unit price, B3 as quantity, and B4 as revenue. Labels make it easier to select the right cells and to interpret the answer later.
  • Check the result independently. Once Excel finds an input, calculate or inspect the result again and verify it matches the target closely enough for your purpose. A displayed value may be rounded by cell formatting, so increase decimal places if the underlying result needs closer inspection.
  • Start with a reasonable input. The value already in the changing cell can affect where Goal Seek searches, particularly when the formula is nonlinear. If the answer seems implausible, try a sensible starting value and run Goal Seek again, then compare the results.
  • Keep the model simple while diagnosing it. Test Goal Seek first with a small, transparent calculation. Once it works, you can use the same process in a larger workbook, while checking that intermediate formulas and references are correct.

Troubleshooting

Goal Seek is missing or disabled: Confirm you are using the desktop app, not Excel for the web, where Goal Seek is not available. On Windows, open the Data tab and look for What-If Analysis in the Forecast group. On Mac, check Data > What-If Analysis. If the ribbon is narrow, some controls may be collapsed into a menu.

Excel says the Set cell must contain a formula: Select the cell that calculates the result, not a value cell. Enter a formula that uses the input you plan to adjust, verify the result changes when you edit that input, and open Goal Seek again.

The result does not move or Excel cannot find a solution: Check that By changing cell is an input referenced by the Set cell formula. Look for fixed values, incorrect cell references, or formulas that do not depend on that input. Confirm the target is possible within the model. For example, a formula that multiplies a quantity fixed at zero by a price will stay at zero regardless of the price.

The returned value looks wrong: Check units, percentage scaling, and cell formatting. Try a different starting value if the formula is nonlinear, and inspect any intermediate calculations. If the formula has no valid input that produces the target, Goal Seek cannot manufacture one; adjust the target or the model assumptions instead.

The value changed but you wanted to keep the original: If the Goal Seek dialog is still open, choose Cancel. If you already accepted the result, restore the starting input you recorded or use Undo if it is still available and no later changes need to be preserved.

Frequently Asked Questions

Where is Goal Seek in Excel?
In desktop Excel, select Data > What-If Analysis > Goal Seek. In the standard Windows ribbon, What-If Analysis is in the Forecast group. The Mac ribbon may arrange controls differently.

Is Goal Seek available in Excel for the web?
No. Open the workbook in the Excel desktop app for Windows or Mac to use Goal Seek. You can still view or edit the workbook in a browser, but this tool is not available there.

Do I need to enable an add-in to use Goal Seek?
No. Goal Seek is a built-in What-If Analysis command in desktop Excel. Solver is a separate tool and may require enabling the Solver Add-in, but that is not required for Goal Seek.

Can Goal Seek change more than one cell?
No. A Goal Seek run changes one input cell to make one formula cell reach a target. For a model with multiple changing cells or constraints, consider Solver instead.

Why does Goal Seek return an unexpected answer?
The formula may be nonlinear, have more than one possible solution, or use a starting value that leads Excel toward a different result. Check the model and units, try a different sensible starting value, and verify the returned result in the worksheet.

Can I use text or a formula in To value?
Enter a numeric target value, such as 3600 or 0.1 for a 10% stored value. The target should use the same scale and units as the result formula cell.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.