Excel Goal Seek is a one-variable numerical tool: it repeatedly changes an input cell until a formula cell reaches a target value. Microsoft does not publish the exact update rule Goal Seek uses, so it is safest to describe it as an iterative search rather than claim it always uses a particular method, such as Newton’s method.
What Goal Seek does
Goal Seek works backward from a desired result. Normally, you enter inputs in a worksheet and let formulas calculate outputs. With Goal Seek, you specify the output you want and ask Excel to find a value for one input that makes the output match it. In mathematical terms, Excel is looking for an input x for which the formula’s result minus the target is zero.
The feature is useful when a formula is straightforward to calculate in the forward direction but awkward to rearrange by hand. For example, you can ask what width would make a rectangle’s area 150 if its length is fixed. Goal Seek changes the width cell, recalculates the area formula, checks how close the result is to 150, and adjusts the input again as needed.
There are three parts to a Goal Seek request:
- Set cell: the cell containing a formula whose result you want to control.
- To value: the target result, entered as a number.
- By changing cell: the single input cell Excel is allowed to adjust.
The set cell must depend, directly or indirectly, on the changing cell. Goal Seek cannot change several inputs at once, and it does not let you add constraints such as requiring an input to be a whole number or greater than zero.
How the search works
Conceptually, Excel begins with the changing cell’s current value, recalculates the set-cell formula, and compares the calculated result with the target. It then tries another input value based on the results of its calculations. This cycle continues until it finds a sufficiently close result or cannot make useful progress. That is the practical meaning of Goal Seek being an iterative numerical search.
Because the formula is recalculated at different trial inputs, the path depends on the formula’s shape and on the starting value. A smooth, steadily changing formula is usually easier to solve than one that jumps between values, has flat regions, or produces errors for some inputs. A formula can also have more than one input value that gives the same target. Goal Seek returns a solution it reaches; it does not promise to find every solution or prove that its result is the only one.
Excel’s exact Goal Seek algorithm and its internal stopping details are not documented as a general guarantee. Do not assume that it always uses a named method, always finds a root, or always returns an exact match. Its result is an approximate numerical solution, which you should check in the worksheet. Also, the workbook’s settings for iterative calculation are mainly for circular references; they are not a control panel for choosing Goal Seek’s search algorithm.
A concrete example
Suppose a worksheet has a rectangle’s width in A2, its fixed length in B2, and its area in C2. With width 8 and length 15, the area is 120. The layout assumption for the formula in C2 is width in A2 and length in B2; enter =A2*B2. To find the width that produces an area of 150, Goal Seek can change A2 while holding B2 at 15. The result is a width of 10, because 10 multiplied by 15 equals 150.
This example has an easy-to-check answer, but the same setup applies when a formula combines many calculations. Goal Seek does not need you to rearrange the formula algebraically. It only needs a formula result it can recalculate as the chosen input changes.
Run Goal Seek in Excel for Windows
In Excel for Microsoft 365 on Windows, set up the formula and input cells first. Then use this sequence:
- Select Data > What-If Analysis > Goal Seek.
- In Set cell, enter or select the formula cell, such as C2.
- In To value, type the target, such as 150.
- In By changing cell, enter or select the input cell, such as A2.
- Select OK and review the proposed result. Choose OK to keep it or Cancel to return to the previous worksheet values.
Goal Seek changes the worksheet’s input cell; it does not create a separate answer table or save the starting value as a record. If you need to compare scenarios, copy the original inputs elsewhere or save a copy of the workbook before running the tool. On Excel for Mac, Goal Seek is also available from the Data tab’s What-If Analysis menu, though the ribbon layout can differ. Excel for the web may not expose the desktop Goal Seek command in a given account or build, so use the Excel desktop app if you cannot find it.
Accuracy and stopping
Goal Seek aims for a result close to the target, not necessarily one that is identical in every displayed digit. A cell may show a rounded value even when its stored value has additional decimal places. Conversely, a number that appears to match the target because of cell formatting may still differ internally. After the search, inspect the underlying result and consider increasing the number of displayed decimal places.
The quality of an answer also depends on what counts as acceptable for the task. If a calculated area needs to be 150 within a tiny tolerance, check the difference between the formula result and 150. If the input represents something that must be a whole number, such as a count of items, Goal Seek may return a decimal value. It does not enforce integer-only inputs. You may need to test nearby whole-number values or use Solver with an integer constraint.
For a stable calculation, make sure the formula is not relying on volatile or changing external data while you run the search. If the formula depends on a random value, a live data connection, or another changing source, the output can move for reasons unrelated to the trial input. In that situation, first make the calculation repeatable or capture a fixed set of input data.
Common reasons it fails or gives an unexpected answer
A message that Goal Seek could not find a solution does not always mean the workbook is broken. The target may genuinely be unreachable, or the formula may not respond usefully to the input. For example, if a formula always returns 0 or 1 because of a threshold test, it may jump over a target such as 0.5 rather than ever equal it.
- The set cell is not a formula: enter a formula in it and confirm that the changing cell affects that formula.
- The wrong cell is selected: check that the changing cell is the intended input and not a formula cell or unrelated value.
- The target is outside the formula’s possible results: test the formula at several reasonable inputs to see whether it can approach the requested value.
- The starting value leads to an unhelpful search: try a different plausible starting value, especially if the formula has multiple possible solutions.
- The formula encounters an error: check for division by zero, invalid references, or functions that return errors for some trial inputs.
- The result is displayed as rounded: increase decimal places and inspect the actual calculated value before deciding it is exact.
One useful diagnostic is to enter several trial inputs manually and observe the set-cell result. If the result barely changes, changes in jumps, or moves in the opposite direction from what you expected, that behavior helps explain why Goal Seek may struggle. It can also reveal that the input and output are linked through a different cell than you intended.
Goal Seek compared with Solver
Goal Seek is the simpler choice when there is one adjustable input and one target result. It does not offer a list of decision variables, bounds, or other constraints. Microsoft Solver is designed for more involved optimization problems: it can vary multiple cells and apply constraints, such as limits on variables or integer requirements. Solver can also optimize an objective rather than merely match a specified value.
Use Goal Seek when the question is, “What value in this one cell makes this formula equal my target?” Consider Solver when the question is, “What combination of values meets these rules while maximizing or minimizing an outcome?” Solver’s availability and setup can depend on the Excel installation; in desktop Excel, check the Add-ins settings if Solver is not present on the Data tab. Neither tool makes an unsuitable model reliable: the formulas, constraints, and assumptions still need review.
Practical checks before accepting an answer
A Goal Seek result is a calculated candidate, not a validation of the model. Review it in the context of the worksheet, especially if other formulas, charts, or reports depend on the changed cell. A few checks make the result easier to trust:
- Confirm the formula cell and input cell are the intended ones.
- Recalculate or inspect the formula result after accepting the solution.
- Compare the output with the target at a suitable level of precision.
- Check whether the input is valid for the real-world meaning of the model, such as a nonnegative or whole-number quantity.
- Keep a copy of the original input if you need to reproduce or explain the calculation.
These checks matter because Goal Seek only solves the relationship represented by the worksheet formula. If the formula omits a relevant factor or contains an incorrect assumption, the tool can still produce a mathematically consistent answer to the wrong model.
Frequently Asked Questions
Does Excel Goal Seek use Newton’s method?
Microsoft does not specify Goal Seek’s exact update algorithm as a general guarantee. It is more accurate to call it an iterative numerical search than to state that every Goal Seek calculation uses Newton’s method.
Can Goal Seek change more than one cell?
No. Goal Seek changes one cell per run. For multiple changing cells or constraints, use Solver or reorganize the problem so that a single input represents the decision you want to test.
Why does Goal Seek return a value that is not exact?
It seeks a numerical approximation, and the formula may not reach the target exactly at a representable input value. Cell formatting can also hide small differences, so inspect more decimal places and check the calculated result against the target.
Can Goal Seek find every possible answer?
No. A formula can have multiple solutions, and the result may depend on the starting input and the search path. Goal Seek returns a solution it reaches; try different starting values or use another method if you need to investigate alternatives.
Is Goal Seek available in Excel for the web?
Availability can vary by web experience and build. If you cannot find Goal Seek under the Data tab, open the workbook in desktop Excel for Windows or Mac, where the desktop command is available.
Related
- Excel Data Validation Date Picker: Limits and Options
- Excel Data Validation Colour Change: Rules and Options
- Excel Data Validation Date Format Explained
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Can You Create a Heat Map in Excel? A Practical GuideYes. In Excel for Microsoft 365 on Windows, select your numeric cells and choose Home > Conditional Formatting…
- Can You Hide a Column in a Power BI Table Visual?Not with a dedicated hide-column switch in a Power BI table visual. To make a column disappear, remove…
- How to Add Reference Footnotes in Word, Step by StepTo add a reference footnote in Word, place the cursor after the passage you are citing, choose References…
- Excel: Group Rows by the Same ValueYes. In Excel for Microsoft 365 on Windows, sort your records by the value you want to group,…
- VALUE Excel Cell Reference: Convert Text to NumbersIf A1 contains number-like text such as 42, enter =VALUE(A1) to convert it into the numeric value 42.…
- Google Sheets Current Timestamp: Insert or Update ItTo show the current date and time in Google Sheets, enter =NOW() in a cell. It updates when…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.