Excel Goal Seek May Not Find a Solution: What to Do

How-to basics · Updated November 18, 2026

When Excel says Goal Seek may not have found a solution, it means the calculation did not reach the requested target under its search—not necessarily that no solution exists. Check that the target cell contains a formula linked to the changing cell, then try a sensible starting value and confirm that the formula can actually produce the target.

What the message means

Goal Seek works by changing one input cell and recalculating a formula cell until the formula’s result approaches a value you specify. If Excel stops without reaching the goal closely enough, it displays a warning. The message is a reason to inspect the result, not proof that your model is wrong or that a solution is mathematically impossible.

There are two broad possibilities. A solution may exist, but Goal Seek may not reach it from the current starting value or through the formula’s behavior. Or there may be no valid input that produces the requested result. A third possibility is a setup problem: for example, the selected output cell is a fixed number rather than a formula.

After the message appears, inspect the worksheet before accepting the displayed values. The changing cell may have moved, and the target cell may now be closer to the goal even if it is not an exact match. Decide whether that difference is acceptable for your purpose; do not assume the warning means the displayed answer is reliable.

How Goal Seek works in Excel

In Excel for Microsoft 365 on Windows, open Data > What-If Analysis > Goal Seek. Enter the formula cell in Set cell, the desired result in To value, and the input cell Excel may adjust in By changing cell. Select OK to run the search. Goal Seek changes one cell at a time, so it is suited to questions such as “What price gives this revenue?” rather than problems involving several independent inputs.

The set cell must calculate a value that depends, directly or through other formulas, on the changing cell. Excel recalculates the result as it adjusts the input. It uses an iterative numerical search, so its success depends partly on the formula’s shape and the starting value. It is not a general-purpose proof that a solution exists, nor does it automatically search every possible input.

Goal Seek is available in the desktop Excel application. In Excel for the web, use desktop Excel for this tool if it is not available in the ribbon. On a Mac, the ribbon layout can differ by version; look on the Data tab for What-If Analysis and Goal Seek. The dialog still asks for a set cell, target value, and changing cell.

Check the three Goal Seek fields

Many failures come from selecting the wrong cells or setting a goal that does not match the model. Before rerunning Goal Seek, verify each field:

  • Set cell: Select the formula whose result you want to control. A typed value cannot respond to changes in another cell.
  • To value: Enter the target as a number, using the same units as the formula result. If the formula returns dollars, a target of 500 means 500 dollars, not 500 percent.
  • By changing cell: Choose one input cell that the set-cell formula depends on. It should be an input, not another formula you expect Excel to overwrite.

For example, assume B2 contains a unit price of 125, B3 contains a starting quantity, and C2 is the result cell. Enter the following formula in C2:

=B2*B3

To make revenue equal 10,000, set C2 to 10000 and allow Goal Seek to change B3. The exact quantity is 80 because 125 multiplied by 80 is 10,000. If you accidentally select B2 as the changing cell, Goal Seek may instead alter the price; if C2 is not the formula cell, it will not solve the intended question.

Why Goal Seek may not reach the target

The target is impossible. Some formulas cannot produce every number. Assume B1 is the input and B2 contains this formula:

=B1^2

For any real number in B1, B2 is zero or positive. Asking Goal Seek to make B2 equal -1 has no real solution. Changing the starting value cannot fix a target that the formula cannot produce.

The formula has a flat or abrupt response. If a small change in the input barely changes the result, the search may struggle to identify a useful direction. Formulas using rounding, thresholds, lookups, or IF conditions can produce steps or jumps rather than a smooth range of results. Assume B1 is an input and C1 contains =ROUND(B1,0). C1 returns whole numbers, so asking it to equal 4.5 is impossible, even though inputs near 4.5 may seem relevant.

There are multiple solutions or a narrow useful range. A formula can reach the same target at more than one input. The result Goal Seek finds can depend on the starting value, and it may not find another valid answer elsewhere. If the result is unexpected, try a different plausible starting value and check whether the formula behaves differently across the relevant range.

The calculation produces an error or stale result. If changing the input causes a formula error such as #DIV/0! or #VALUE!, Goal Seek cannot use that result as an ordinary numeric target. Also check whether calculation is set to automatic: use Formulas > Calculation Options > Automatic, then recalculate if needed. A workbook in manual calculation mode may show results that have not updated as expected.

A practical troubleshooting sequence

Use this order to distinguish a setup issue from a mathematical limitation:

  1. Write down the result you want and the one input you are willing to change. Confirm that the intended formula depends on that input.
  2. Run the worksheet manually with two or three reasonable input values. Note whether the output moves toward, away from, or past the target.
  3. Check for blanks, text stored as numbers, formula errors, rounding, IF thresholds, and accidental references to the wrong cells.
  4. Choose a sensible starting value near the range where you expect the answer. If the formula behaves differently in another range, try a second starting value.
  5. Run Goal Seek again, then compare the resulting formula value with the target. Check the underlying input and output at the displayed precision, not just the rounded number shown in the cell.
  6. If the warning returns, decide whether the target is attainable and whether the difference is material. If you need tighter control or more variables, choose a more suitable method.

Testing a few inputs is especially useful when a model includes business rules. For instance, a tax, commission, or shipping formula may change only after a threshold is crossed. If the output stays constant across a broad range and then jumps, the target may fall between the formula’s possible outputs. Goal Seek cannot make a stepwise formula return a value it never produces.

Check precision and interpret the result

Displayed values can hide differences. A cell formatted to show two decimal places might display 12.35 even when the stored value is 12.3457. Compare the unrounded result with your target, and consider the units and precision that matter in the real model. Increasing displayed decimal places can help diagnose the difference, but formatting does not change the underlying calculation.

Also distinguish an approximate result from an exact one. A formula involving division or nonlinear calculations may have a valid input that gets very close to the goal without producing a neat decimal answer. If the decision requires a whole number—such as a number of units or people—rounding the answer afterward can change the result. Recalculate the formula using the rounded input and verify that it still meets the requirement.

Keep a copy of the original input before running Goal Seek if you need to compare scenarios. Goal Seek changes the worksheet’s changing cell; it does not create a separate scenario record. You can undo a run with the normal Undo command, but recording the original value or using a duplicate worksheet makes comparisons clearer.

When to use Solver or another approach

Use Goal Seek when you have one formula result, one target, and one adjustable input. Use Excel Solver when the model needs several changing cells, constraints such as minimums or maximums, or an objective to maximize or minimize. Solver is a separate Excel add-in; on Windows, if it is not on the Data tab, enable it through File > Options > Add-ins, select Excel Add-ins beside Manage, choose Go, and select Solver Add-in. Solver is also available for desktop Excel on Mac, though its setup and ribbon placement can vary.

Solver is not a guarantee of a solution either. It has different solving methods and options, but a poor model, impossible constraints, or a difficult formula can still prevent a useful result. For a simple one-input problem with a known interval, manual trial values or a small table of inputs and outputs can make the formula’s behavior easier to understand. A Data Table is useful for comparing many inputs, but it does not replace Goal Seek when you want Excel to search for one input value.

Frequently Asked Questions

Does the warning mean Goal Seek found no solution?
No. It means the search did not report a successful match. A solution may exist but be difficult to reach from the starting value, or the target may be impossible for the formula. Check the resulting values and test the formula before drawing a conclusion.

Why does Goal Seek change the wrong cell?
The changing cell is whatever you entered in By changing cell. Reopen the dialog and select the intended input. Confirm that the set-cell formula depends on it; otherwise changing it cannot affect the target in the way you expect.

Can Goal Seek change more than one cell?
No. Goal Seek adjusts one changing cell for one formula result. For multiple decision variables or constraints, use Solver if the problem fits its capabilities.

Why does Goal Seek return a different answer when I change the starting value?
The formula may have more than one solution, or its response may vary across different ranges. Goal Seek searches iteratively from the value already in the changing cell; it does not promise to locate every possible solution.

Can I use Goal Seek with a formula containing IF or ROUND?
Yes, provided the set-cell formula ultimately depends on the changing cell, but conditional and rounded formulas can have flat sections or jumps. The requested target may not be one of the values that formula can return, so test several inputs and verify the 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.