Excel Goal Seek Not Working? Fix These Common Problems

If Excel Goal Seek is not working, first confirm that the Set cell contains a formula linked to the By changing cell, then open Data > What-If Analysis > Goal Seek and enter a numeric target. Goal Seek can adjust only one input cell at a time, and it cannot find a meaningful result if changing that input does not affect the formula.

Most failures come from a broken dependency, the wrong cell selection, or a model that has no usable solution. The checks below help identify which one applies and explain when Goal Seek is the wrong tool.

Check the Goal Seek setup first

In Excel for Microsoft 365 on Windows, select Data > What-If Analysis > Goal Seek. Fill in the dialog as follows:

Set cell: Select the cell containing the formula whose result you want to reach. It must be a formula cell, not a typed value.
To value: Enter the numeric result you want. For example, enter 1200 rather than typing a currency symbol or a sentence.
By changing cell: Select the single input cell Excel is allowed to adjust. It should contain a value, not a formula.

Click OK to let Excel search, then review the proposed result in the worksheet. The Goal Seek Status dialog reports whether Excel found a solution; choose OK to keep the proposed values or Cancel to restore the original values. If the dialog will not run or returns an unexpected answer, check the cell references before changing the model.

In Excel for Mac, Goal Seek is also under Data > What-If Analysis > Goal Seek, although ribbon layout can vary slightly by release. Excel for the web does not provide the desktop Goal Seek command; open the workbook in the desktop app to run it.

Make sure the formula depends on the input

Goal Seek works by changing the input cell and recalculating the formula in the Set cell. If the formula does not use the input, directly or through other formulas, changing the input cannot move the result. This is one of the most common reasons a search appears stuck or ends at an unchanged value.

For a basic example, put the number of items in B1, the price per item in B2, and the calculated sales total in B3. With those cells, enter =B1*B2 in B3. If B2 contains 12 and you want B3 to equal 1200, set B3 as the Set cell, enter 1200 as the target, and use B1 as the changing cell. Goal Seek should return 100 items because 100 multiplied by 12 is 1200.

If the total formula instead refers to a different input cell, or contains a fixed number where you expected a cell reference, Goal Seek cannot change the intended value. Click the Set cell and inspect its formula bar. Trace the referenced cells if necessary, and confirm that the changing cell is part of that calculation chain.

Confirm the cells are the right type

The Set cell must return a numeric result from a formula. A formula that returns text, such as a message, is not a useful target. The changing cell should be a single numeric input, such as a quantity, rate, or cost. Selecting a range, a label, or a formula cell as the changing cell can prevent the search from working as intended.

Also check whether the apparent number is actually stored as text. Values imported with leading apostrophes, spaces, or text formatting may look numeric but behave differently in calculations. Click the cell and inspect its contents; if arithmetic or other formulas do not treat it as a number, convert it to a real numeric value before running Goal Seek. Avoid selecting a cell with a data-validation restriction that rules out the values the search needs.

Displayed values can also be misleading. A cell formatted to show two decimal places might display 10.00 while storing 9.996. Goal Seek works with the underlying value, not merely the rounded display. Increase the displayed decimal places temporarily if a result seems close but not exact.

Look for a valid solution and a sensible starting value

Goal Seek is a numerical search, not a proof that a solution exists. It adjusts the input and recalculates the result until it gets sufficiently close to the target or stops without finding a satisfactory value. If no possible input can produce the target, there is nothing for it to find. For example, if a model caps a result at 500, asking for 700 is impossible unless the cap or another assumption changes.

The starting value matters because some formulas behave differently across their input range. A formula may have a denominator that becomes zero, a threshold, a lookup boundary, or a square root that is only defined for certain inputs. Start with a plausible value in the changing cell and inspect how the Set cell responds to small changes. If the result jumps, stays flat, or produces an error, understand that behavior before asking Goal Seek to search.

Check whether the target is reachable by trying a few reasonable inputs manually. If increasing the input always increases the result, but even a very large realistic input remains below the target, the target may be out of range. If the result moves in the opposite direction from what you expect, confirm the formula and signs, such as whether costs are represented as negative numbers.

Check calculation mode and formula errors

When formulas appear not to update, verify calculation settings under Formulas > Calculation Options. Automatic calculation is the usual setting for interactive models. If calculation is set to Manual, formulas may display stale results until recalculated; press F9 on Windows to calculate, or use Fn+F9 on many Mac keyboards (the Fn key requirement depends on keyboard settings). You can also switch to Automatic and check whether the displayed result changes.

Inspect the formula chain for errors such as #VALUE!, #DIV/0!, or #N/A. A dependent formula that returns an error cannot provide a normal numeric result for Goal Seek to match. Resolve the error at its source, then confirm that the Set cell displays a number before starting the search. A circular reference can also make results unstable or dependent on iterative calculation settings. Unless the workbook intentionally uses a circular model, remove the circular reference rather than relying on it.

Be careful with formulas that use rounding. If a result is rounded to whole numbers, many nearby input values can produce the same displayed result. Goal Seek may find a value that meets the formula’s actual target, but a rounded display can make the outcome look inaccurate. Compare the underlying formula result and the target, not just the formatted appearance.

Understand what Goal Seek can and cannot do

Goal Seek is designed for a single target formula and a single changing cell. It is useful for questions such as how many units must be sold to reach a sales total, what interest rate makes a payment formula equal a target, or what input produces a chosen percentage. It does not directly solve for several unknowns at once, impose multiple constraints, or optimize a result such as maximizing profit.

For a model with two or more inputs that must change together, or with restrictions such as a budget ceiling or whole-number quantities, use Solver instead. In desktop Excel, Solver is an add-in; if it is not visible, enable it through File > Options > Add-ins, choose Excel Add-ins in the Manage box, click Go, and select Solver Add-in. Solver can handle more complex optimization and constraints, but it requires a properly defined objective and variable cells.

For scenarios where you want to compare predefined combinations rather than search for one target, a one-variable or two-variable data table may be more suitable. These tools show how a formula responds across a range of inputs. They answer a different question from Goal Seek, which works backward from one desired result.

Keep the result and verify it

Goal Seek changes the worksheet’s input cell when you accept its result. Before running it on an important workbook, note the original value or save a copy. This matters when the input represents an assumption used in other calculations: accepting a new value can change totals, charts, and reports elsewhere in the workbook.

After accepting a result, recalculate and check the formula and the changing cell. Confirm that the target is met to the precision the model requires, that the input is realistic, and that dependent calculations still make sense. If the result is close but not adequate, inspect rounding and formula logic instead of repeatedly accepting unexplained values. Goal Seek provides a numerical answer to the model as written; it does not validate the assumptions behind that model.

Frequently Asked Questions

Why is Goal Seek greyed out in Excel?
Check that you are using the desktop version of Excel, not Excel for the web, and that a workbook is open. If the command is unavailable in the ribbon, look under Data > What-If Analysis. Also confirm that the workbook is not in a state that prevents editing, such as a protected sheet; protection may need to be removed before the changing cell can be modified.

Does the Set cell have to contain a formula?
Yes. The Set cell is the result Excel tries to match, so it needs a formula that calculates a numeric value. A typed constant cannot respond to changes in another cell, and a text result cannot serve as a normal numeric target.

Can Goal Seek change more than one cell?
No. Goal Seek changes one input cell for one formula result. If several input values must vary together, or the answer must satisfy additional conditions, use Solver or redesign the model as a sequence of separate calculations.

Why does Goal Seek say it may not have found a solution?
The target may be unreachable, the formula may not respond to the input, or the search may encounter a discontinuity, error, or unsuitable starting value. Test plausible inputs manually, verify the formula references, and check that the Set cell remains numeric across the range.

Can I use Goal Seek in Excel for the web?
Goal Seek is not available as a command in Excel for the web. Open the workbook in Excel for Microsoft 365 on Windows or the desktop Mac app, run Goal Seek there, and then save the workbook so the result is available online.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.