In Excel for Microsoft 365 on Windows, Goal Seek works backward from a desired formula result: choose Data > What-If Analysis > Goal Seek, set the formula cell and target value, then name the one input cell Excel may change. It is useful when you know the answer you want but need to find the input that produces it.
What Goal Seek does
Goal Seek is Excel’s built-in, single-variable what-if analysis tool. Instead of changing an input and observing the output, you tell Excel the output you want and let it adjust one input until the formula reaches that target. The worksheet remains a normal model: formulas calculate results from values in cells, and Goal Seek changes a value in one of those cells.
For example, you might know the revenue target for a product and want to find the selling price that would reach it at a fixed sales volume. Or you might want to find the exam score needed to reach a particular course grade, assuming the other scores and grading weights are already known. These are backward-calculation questions with one adjustable input.
Goal Seek does not create a new formula or a separate forecast. It changes the value in the specified input cell and recalculates the workbook. The tool is available in the desktop versions of Excel, including Excel for Microsoft 365; it is not the same as the more advanced Solver add-in.
Understand the three Goal Seek fields
The Goal Seek dialog has three fields. Knowing what each one represents makes it easier to set up a useful calculation:
- Set cell: The cell containing the formula whose result you want to control. It must calculate from the changing input, directly or through other formulas.
- To value: The target result. Enter a number, such as 6000 or 85. This field is not a cell reference or a formula.
- By changing cell: The single input cell Excel is allowed to adjust. It should contain a value, not the formula you are trying to solve.
In short, the Set cell is the output, To value is the desired output, and By changing cell is the input. If the output formula does not depend on the selected input, changing that cell cannot help Excel reach the target. A well-organized worksheet makes these relationships visible, with assumptions in input cells and calculated results in formula cells.
A simple worked example
Suppose a business sells 240 units, and the current price is $18 per unit. The current revenue is $4,320, but the target is $6,000. If sales volume stays fixed, Goal Seek can find the price that reaches the target.
Put the number of units in B2, the price in B3, and the revenue result in B4. With those cell positions, enter this formula in B4: =B2*B3. At the starting values, 240 multiplied by 18 equals 4,320.
Open Goal Seek and use B4 as the Set cell, 6000 as the To value, and B3 as the By changing cell. Excel changes the price to $25, because 240 multiplied by 25 equals $6,000. The answer is a price for this simplified model, not a prediction that customers will actually buy 240 units at that price. Goal Seek respects the worksheet’s formula; it does not assess whether the assumptions are realistic.
This example also shows why the formula cell and input cell must be different. B4 calculates revenue, while B3 supplies a price. If B3 were not used in the revenue formula, Goal Seek could not use it to change the result.
How to run Goal Seek in Excel
On Excel for Microsoft 365 for Windows, first enter and check the formula and input values. Then follow these steps:
- Select Data > What-If Analysis > Goal Seek.
- In Set cell, enter or select the cell containing the result formula.
- In To value, type the target number you want the formula to return.
- In By changing cell, enter or select the one input cell Excel may adjust.
- Select OK to let Excel calculate, then review the result in the worksheet and the Goal Seek Status message.
- Choose OK to keep the found value, or Cancel to return to the previous value.
Use cell references rather than typing values into the wrong fields: the Set cell should be the formula cell, and the changing cell should be the input. If the target involves a percentage, check how that percentage is stored and displayed. For instance, a cell formatted as a percentage may display 25% while its stored value is 0.25; Goal Seek works with the underlying numeric value.
What the result means—and what it does not
Goal Seek searches for a numeric value that makes the selected formula approach the target. The found value is written into the changing cell, and dependent formulas recalculate. It does not add a note explaining the assumptions, save a permanent record of the old input, or prove that the answer is unique or sensible. If the workbook contains several formulas depending on that input, all of them may change too.
Check the result in context before using it. Confirm that the target cell is close enough to the desired value, the input is in a plausible range, and related outputs still make sense. A displayed result may be rounded by cell formatting, so increase the displayed decimal places if you need to inspect precision. If you need to retain both the original and solved values, record the original separately or make a copy of the worksheet before running Goal Seek.
Goal Seek generally finds a solution numerically rather than deriving a symbolic equation. A result may therefore be approximate, and some formulas can have multiple possible solutions or no solution in a reasonable range. Try a different starting value when the answer seems unexpected, and verify the result by checking the formula and inputs yourself.
Limits and common problems
Goal Seek is deliberately narrow: it changes one cell to reach one target in one formula. It does not enforce limits such as a price being nonnegative, an employee count being a whole number, or a budget staying below a cap. If an unconstrained answer is invalid for your situation, Goal Seek will not automatically reject it.
Common problems usually come from setup or model design:
- The Set cell is not a formula: Select the calculated output, not a typed result or an input cell.
- The changing cell does not affect the result: Check that the formula depends on that input through its calculation chain.
- The answer seems unreasonable: Review units, percentage storage, signs, references, and assumptions. A formula can be correct while its model is unrealistic.
- The tool reports it could not find a solution: The target may be unreachable, the formula may have a discontinuity, or the starting value may make the search difficult. Check the model and try a sensible starting input.
- The answer violates a rule: Goal Seek has no bounds or constraints. Use Solver when the problem needs restrictions or several changing cells.
A circular-reference warning is a separate workbook issue, not a normal requirement for Goal Seek. Make sure the output formula can calculate as intended before using the tool; do not enable iterative calculation just because you want to run a basic Goal Seek.
Goal Seek compared with Solver and other tools
Choose a tool based on how many inputs and rules the question involves. Goal Seek is the simplest choice when there is one target formula and one adjustable input. It is quick for questions such as “What price gives this revenue?” or “What score reaches this average?”
Solver is better when several cells may change, or when the answer must satisfy constraints such as minimums, maximums, integer values, or resource limits. Solver is an Excel add-in, so it may need to be enabled through Excel’s add-in settings. It can optimize a target, such as maximizing profit, as well as seek a specified result. Goal Seek cannot do those multi-variable or constrained tasks.
Other what-if tools serve different purposes. A one- or two-variable Data Table shows how a formula changes across a range of possible inputs, which is useful for comparing scenarios rather than finding one input for one target. Scenario Manager stores and compares sets of input values. Goal Seek answers a backward question; a Data Table or Scenario Manager is often more useful when the aim is to compare several possible assumptions.
Excel for Mac and Excel for the web
In current desktop Excel for Mac, the Goal Seek command is available from Data > What-If Analysis > Goal Seek, although ribbon layout and dialog appearance can vary by release. The basic fields and method are the same as in Windows Excel. If the command is not visible, check that you are using the desktop application and that the Data tab is available in the ribbon.
Excel for the web does not provide the desktop Goal Seek command in the same way. Open the workbook in the Excel desktop app to run Goal Seek, then save the workbook so its changed input and recalculated result are available online. A workbook’s formulas can still be viewed and edited in the browser, but that is different from running the Goal Seek analysis tool.
Frequently Asked Questions
Does Goal Seek change a formula?
It changes the value in the By changing cell, not the Set cell formula. The formula recalculates using the new input, so check that the formula itself is correct before trusting the result.
Can Goal Seek change more than one cell?
No. Goal Seek adjusts one changing cell for one target formula. Use Solver if your model needs multiple adjustable cells or constraints.
Can I use Goal Seek to find a percentage?
Yes, if the percentage is an input cell used by the target formula. Enter the target as the numeric value the formula should return, and check whether the cell’s percentage format hides a decimal value such as 0.25.
Why does Goal Seek give a strange answer?
It may be following the formula correctly while the model, units, starting value, or assumptions are wrong. Check those details and confirm that the found input is realistic for the question you are modeling.
Can I undo a Goal Seek result?
After accepting it, use Undo or restore the original input value. For a safer comparison, note the original value or duplicate the worksheet before running Goal Seek.
Related
- Excel Split Cell by Space Delimiter: Methods and Tips
- Excel Sheet Protection: How to Protect and Unlock Cells
- Excel Remove Duplicates: Safe Steps and Alternatives
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Slow? Causes, Fixes, and Ways to Speed It UpIf Excel is slow, first find out whether the delay affects one workbook or every workbook, then check…
- Excel Dropdown List Dynamic Range: Setup and FixesTo make an Excel dropdown list use a dynamic range, store its choices in an Excel Table and…
- Bi-Monthly Budget Template in Google Sheets: Setup GuideA bi-monthly budget template in Google Sheets can track income, planned spending, and actual expenses for each pay…
- Excel Text to Columns: How to Keep Leading Zeros SafelyYes—Excel Text to Columns can keep leading zeros, but you must set the affected column’s format to Text…
- Excel Shortcut to Select a Whole Column in SecondsIn Excel for Microsoft 365 on Windows, select any cell in the column and press Ctrl+Space to select…
- Excel Column Alphabetical Order: A to XFD ExplainedExcel’s worksheet columns are labeled A through Z, then AA through AZ, BA through BZ, and onward to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.