Goal Seek Button in Excel: Where It Is and How to Use It

How-to basics · Updated November 21, 2026

In Excel for Microsoft 365 on Windows, find Goal Seek at Data > What-If Analysis > Goal Seek. To use it, choose a formula cell to set to a target value, then identify the single input cell Excel may change to reach that target.

Where to find the Goal Seek button

Goal Seek is a command on Excel’s Data tab, inside the What-If Analysis menu. The full Windows path is Data > What-If Analysis > Goal Seek. The command opens a small dialog rather than a separate worksheet or a permanent button added to the sheet.

If you cannot see the command, make sure you are using the desktop version of Excel and that the ribbon is expanded. A narrow Excel window can compress ribbon groups, but the Data tab and its menus should still be available. Excel for the web does not provide the desktop Goal Seek command; open the workbook in the Excel desktop app to run it.

In current desktop versions of Excel for Mac, look on the Data tab for What-If Analysis and Goal Seek. The exact ribbon arrangement can differ from Windows, and older Mac releases may place Goal Seek under the Tools menu. If you are following Windows instructions on a Mac and do not see the command, check the Data and Tools menus for your installed version.

What Goal Seek does

Goal Seek works backward from a result. Normally, you enter an input, and a formula calculates an output. With Goal Seek, you specify the output you want and tell Excel which one input it is allowed to adjust. Excel repeatedly recalculates the formula until it finds an input that produces a result close to your target.

The three fields in the dialog have distinct jobs:

  • Set cell: the cell containing the formula whose result you want to target.
  • To value: the target result, entered as a number. It is a value, not a formula.
  • By changing cell: the one input cell Excel can alter while searching for the target.

For example, a business might know its planned number of units and want to find the unit price that produces a particular sales total. The total is the formula cell, the desired sales total is the target, and the price is the changing cell. Goal Seek is useful when the relationship is already represented in a worksheet formula and solving it by hand would be inconvenient.

How to run Goal Seek step by step

  1. Build or check the worksheet formula that calculates the result you care about. The result cell must contain a formula, not just a number typed in directly.
  2. Select Data > What-If Analysis > Goal Seek.
  3. In Set cell, enter or select the formula cell. Use a cell reference such as B4, not the formula text itself.
  4. In To value, type the numeric result you want. Enter 18000 for a target of eighteen thousand; apply currency formatting to the cell separately if appropriate.
  5. In By changing cell, select the single input cell Excel is allowed to vary. That cell should be referenced by the formula, either directly or through other formulas.
  6. Choose OK to let Excel search. Review the result and choose OK to keep the solution, or Cancel to restore the original value.

Goal Seek changes the value in the changing cell when you keep the result. It does not create a separate copy of the worksheet or preserve the previous input automatically. If you want to compare the original and solved versions, record the original value first, copy the sheet, or save a separate workbook version.

A simple worked example

Suppose a worksheet has the planned quantity in B2, the unit price in B3, and total sales in B4. Put 240 in B2 and 68 in B3. With that layout, enter this formula in B4:

=B2*B3

The current total is 240 multiplied by 68, or 16,320. If the target total is 18,000, open Goal Seek and set the fields as follows: Set cell B4, To value 18000, and By changing cell B3. Excel changes the price to 75 because 240 multiplied by 75 equals 18,000. The quantity stays fixed; only the specified price cell changes.

This example also shows why cell roles matter. If B4 contains a typed number rather than the multiplication formula, Excel has no calculation to adjust. If you select B2 as the changing cell instead, Goal Seek will try to change the quantity rather than the price. The tool follows the cell references and instructions you give it; it does not infer which business assumption you intended to vary.

What Goal Seek can and cannot solve

Goal Seek is designed for a formula with one adjustable input cell. It can be useful for questions such as what price reaches a revenue target, what test score produces a desired course average, or what monthly payment input makes a spreadsheet’s calculated balance reach a specified level. Those are worksheet calculations, not recommendations about what price, score, or payment should be chosen in real life.

It is not a general-purpose optimizer. You cannot ask standard Goal Seek to adjust several cells at once, enforce conditions such as a minimum stock level, or find the best result across multiple competing objectives. For those tasks, Solver may be more appropriate. Goal Seek also cannot change a constant formula cell into a target: the Set cell needs a formula whose result responds to the changing input.

Because Excel searches numerically, it may find an approximate answer rather than a mathematically exact one. Some formulas have more than one possible solution, and a nonlinear formula can behave differently depending on the starting input. In that situation, Goal Seek may find one solution, fail to converge, or return a result that deserves further checking. It does not prove that a unique solution exists.

Common problems and how to fix them

  • Goal Seek is unavailable: Confirm that you are in desktop Excel, not Excel for the web, and check the Data tab’s What-If Analysis menu. On Mac, menu placement can depend on the release.
  • The Set cell is rejected or the result does not move: Check that the selected cell contains a formula and that the formula depends, directly or indirectly, on the changing cell.
  • The wrong assumption changes: Reopen the dialog and verify the By changing cell field. Excel will alter only the cell named there, so choosing a quantity instead of a price changes the meaning of the result.
  • The result is close but not exact: Review the formula and its displayed precision. A formatted cell may show fewer decimal places than its stored value, and Goal Seek works to a numerical tolerance rather than promising exact equality.
  • Excel cannot find a useful value: Try a sensible initial value in the changing cell, check that the target is attainable, and look for formulas that produce errors or discontinuities near the expected solution.

For a nonlinear model, test the result by recalculating the worksheet and inspecting the actual formula output. You can also try a different starting value if there may be several solutions. A plausible-looking input is not enough by itself: make sure it fits the assumptions and units used by the model.

Goal Seek compared with Solver and other What-If tools

Goal Seek is the simplest option when you know the target output and want Excel to adjust one input. Solver is intended for more involved optimization problems: it can vary multiple decision cells and work with constraints, such as requiring values to be nonnegative. Solver is a separate Excel add-in, so it may need to be enabled before its command appears. It is not necessary just to run ordinary Goal Seek.

Data Tables answer a different question: how would a formula’s result change across a range of one or two input values? They are useful for comparing many assumptions at once, whereas Goal Seek searches for an input matching one chosen target. Scenario Manager stores and compares sets of input values. All three are grouped under What-If Analysis in desktop Excel, but they are not interchangeable.

A practical choice is to use Goal Seek for one target and one variable, a Data Table to compare a grid of possible inputs, Scenario Manager to save named input combinations, and Solver when the task involves several changing cells or constraints. If the relationship is simple enough to solve directly with arithmetic, a regular formula may be easier to audit than any what-if tool.

Frequently Asked Questions

Why can’t I find Goal Seek in Excel?
In Windows desktop Excel, check Data > What-If Analysis > Goal Seek. The command is not available in Excel for the web. On a Mac, check the Data tab and, in older releases, the Tools menu.

Does Goal Seek work with more than one changing cell?
No. Standard Goal Seek changes one cell at a time. Use Solver when you need multiple changing cells or constraints, or restructure the problem into separate steps if that suits the model.

Does the Set cell have to contain a formula?
Yes. It must be a calculated result that depends on the changing cell. A constant value cannot respond to Excel’s input adjustments, so Goal Seek has nothing to solve.

Does Goal Seek save the answer automatically?
It keeps the changed input in the worksheet if you accept the result in the dialog. The original input is not saved as a separate scenario, so record it or make a copy first if you need to compare both values.

Can Goal Seek find every possible answer?
No. It searches for a solution to the target, but does not list every possible solution or guarantee that a solution is unique. For formulas with multiple roots or complex behavior, test different starting values and verify each result.

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.