Excel Goal Seek: How to Find the Input Value You Need

How-to basics · Updated November 21, 2026

In Microsoft Excel for Microsoft 365 on Windows, use Data > What-If Analysis > Goal Seek to find the input that makes a formula return a value you choose. Select the formula cell as the Set cell, enter the desired result in To value, and identify one input cell in By changing cell.

What Excel Goal Seek Does

Goal Seek is a built-in what-if analysis tool. Instead of asking what result follows from a particular input, you give Excel a result and ask it to work backward to an input that produces it. For example, if a formula calculates the area of a rectangle, Goal Seek can find the width needed to reach a chosen area when the length is fixed.

The tool changes one numeric cell and recalculates the formula in a different cell until it gets close to the target. The formula must depend, directly or through other formulas, on the changing cell. Goal Seek does not rewrite the formula or create a new calculation model; it adjusts the input value in the worksheet.

This makes it useful for questions such as “What quantity gives this total?” or “What score is needed to reach this average?” It is not a general-purpose optimizer: it does not search several inputs at once, apply constraints, or decide whether the target is the best possible result.

How Goal Seek Works

Goal Seek needs three pieces of information. The Set cell is the cell containing the formula whose result matters. To value is the result you want that formula to reach. By changing cell is the single input Excel may adjust. The changing cell should be a numeric input, not the formula cell itself, and the formula must be connected to it.

Excel tries different values in the changing cell and recalculates the dependent formula. It stops when it finds a result sufficiently close to the target or when it cannot make further progress. This is a numerical search, not a symbolic solution: Excel does not rearrange your formula algebraically, and the outcome can depend on the formula’s shape and the starting value.

There may be more than one input that produces a target, or none at all. Goal Seek returns a solution it finds; it does not prove that the solution is unique or that it is the only valid one. For a complicated formula, test the result and consider trying a different starting input if the first answer seems unexpected.

Run Goal Seek Step by Step

Here is a simple example with a checkable answer. Suppose a rectangle has a fixed length of 10 units, and you want its area to be 120 square units. With the width in B2, the fixed length 10 in B3, and the area formula in B4, enter =B2*B3 in B4. Goal Seek should find a width of 12 because 12 multiplied by 10 equals 120.

  1. Select a cell in the worksheet, then choose Data > What-If Analysis > Goal Seek. In Excel for Microsoft 365 for Windows, What-If Analysis is on the Data tab.
  2. In Set cell, enter or select B4, the cell containing the area formula.
  3. In To value, type 120. Enter the number itself, not a formula or a cell reference.
  4. In By changing cell, enter or select B2, the width input.
  5. Choose OK to let Excel search. Review the result in the Goal Seek Status dialog. Choose OK to keep the found value, or Cancel to discard it and return to the prior worksheet value.

After accepting the result, check that the area formula still exists in B4 and that the width in B2 is sensible for your model. Goal Seek changes the input cell, so the result is part of the worksheet’s current state. It does not automatically preserve the original input as a separate scenario.

Prepare the Worksheet Before Searching

A well-organized model makes Goal Seek easier to use and its result easier to trust. Keep assumptions and outputs in separate cells, label them clearly, and make sure the formula cell updates when the input changes. If the formula is hard-coded rather than linked to the changing cell, Goal Seek has nothing to adjust toward the target.

Check the units and scale before entering a target. If an output is stored as a decimal but displayed as a percentage, the value to enter may not look like the displayed value. For example, a displayed 25% is stored as 0.25; use the underlying numeric target appropriate to the formula, not a percentage number interpreted differently. Formatting changes how a value appears, not the underlying calculation.

It is also helpful to save a copy or note the original input before running a search, especially in a large model. Goal Seek is not a permanent record of assumptions. If you need to compare several possible inputs later, record the values and outputs in a table or use a tool designed to store or evaluate multiple scenarios.

What the Result Means—and What It Does Not

A successful Goal Seek run means Excel found an input that makes the selected formula reach, or come very close to, the target under the worksheet’s current formulas and assumptions. It does not confirm that those assumptions are correct, that the input is realistic, or that the answer is useful in the real world. Treat the result as a calculation to inspect, not as an independent validation of the model.

Some problems have several mathematical answers. For instance, a formula involving a square can produce the same output from a positive or negative input. Goal Seek may settle on one answer based on its starting point and search path. If the input has practical restrictions—such as needing to be positive, an integer, or within a defined range—check those rules yourself. Goal Seek does not enforce them.

Targets may also be impossible or only approximately attainable. A formula that changes in whole-number steps may skip over the requested result, while a formula with abrupt IF conditions may not respond smoothly. In those cases Excel may report that it could not find a solution, or return a nearby value. Inspect the actual output and decide whether the difference is acceptable for the task.

Common Goal Seek Problems

  • The result does not change: Confirm that the formula in Set cell depends on the By changing cell input. Check references and make sure the input is not text or disconnected from the calculation.
  • The output is close but not exact: The target may be unreachable, or the calculation may use rounding or whole-number steps. Check the unrounded value and the formula before deciding whether to accept the result.
  • The answer seems unrealistic: Goal Seek does not know your valid range or business rules. Verify units, starting values, assumptions, and any limits the model should obey.
  • The tool is unavailable or the dialog cannot run: Make sure a workbook is open and the Set cell is a formula cell. In the dialog, confirm that all three fields contain valid cell or numeric entries.
  • The answer changes after editing another cell: That is expected if the formula depends on other inputs. Goal Seek solves the worksheet as it exists at the time; changing an assumption can change the result.

When the formula is complex, try a sensible starting value and simplify the model temporarily to isolate the issue. Check that calculation is updating normally and that no error value such as #VALUE! or #DIV/0! is already interrupting the formula. A search cannot produce a meaningful answer from a broken calculation.

Goal Seek Compared With Other What-If Tools

Choose the tool based on the question. Goal Seek is suited to one target, one formula result, and one changing input. Excel’s Scenario Manager is more appropriate when you want to save and compare named sets of inputs, such as a low, middle, and high case. A data table is useful when you want to see how one or two inputs affect formula results across a range of values.

Solver is the stronger choice when the model needs to adjust multiple input cells, maximize or minimize an objective, or obey constraints. Solver is an Excel add-in, so it may need to be enabled in the desktop application. It is more flexible than Goal Seek, but it also requires you to set up an objective, variable cells, and any relevant constraints carefully.

These tools answer different questions. A data table shows many calculated outcomes; Scenario Manager saves alternative input sets; Goal Seek works backward from a target; and Solver searches for an optimized result subject to rules. For a straightforward one-variable target, Goal Seek is usually the quickest option.

Availability in Windows, Mac, and Excel for the Web

In Excel for Microsoft 365 on Windows, the command is Data > What-If Analysis > Goal Seek. In Excel for Microsoft 365 for Mac, look on the Data tab for What-If Analysis and choose Goal Seek; the ribbon layout can vary slightly by update and window size. The dialog uses the same three inputs.

Goal Seek is a desktop Excel feature and is not available to run in Excel for the web. If you open a workbook in a browser, use the desktop app to perform the search, then save the workbook so the changed input is available in the file. If you are working on a shared workbook, coordinate edits so another person does not overwrite the input or assumptions while you are evaluating the result.

Frequently Asked Questions

Where is Goal Seek in Excel?
On Windows, choose Data > What-If Analysis > Goal Seek. On Mac, open the Data tab and choose What-If Analysis > Goal Seek. If you cannot see the command, check the ribbon layout or use the desktop version of Excel.

Can Goal Seek change more than one cell?
No. Goal Seek adjusts one changing cell per run. To adjust multiple variables or add constraints, use Solver if it is available and appropriate for your model.

Why does Goal Seek give a different answer than I expected?
The target may have multiple possible inputs, may be unreachable, or may depend on rounding or abrupt formula changes. Check the formula, units, and starting input, then verify the resulting output rather than assuming the first result is the only solution.

Can I use Goal Seek in Excel for the web?
No. Run Goal Seek in the Excel desktop application for Windows or Mac, then save the workbook. Excel for the web can display workbook content but does not provide the Goal Seek command.

Does Goal Seek save the original input?
It changes the worksheet’s input cell when you accept a result; it does not create a saved before-and-after scenario. Record the original value, duplicate the worksheet, or use Scenario Manager if you need to preserve and compare alternatives.

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.