Excel Goal Seek Tolerance: Set Precision and Check Results

How-to basics · Updated November 19, 2026

Excel Goal Seek has no per-run tolerance box. Its default calculation setting commonly cited for iterative work is Maximum Change = 0.001, but that is not a guarantee that the target cell will be within 0.001 of your goal; check the result by calculating the remaining difference yourself.

What Goal Seek tolerance means

Goal Seek works backward from a desired result: it changes one input cell until a formula in another cell reaches a value you specify. Because it searches iteratively, it may stop with a result that is close to the target rather than mathematically exact. In this context, tolerance means how close a result must be before the search is accepted as sufficiently close.

There are two different errors worth distinguishing. The target-cell residual is the difference between the formula’s actual result and the requested target. The input-cell change is the amount Excel adjusts the variable between attempts. A small change in the input does not necessarily mean a small residual, especially when the formula is steep, rounded, discontinuous, or nearly flat. Likewise, a displayed value rounded to two decimal places can look exact while the stored value is not.

Goal Seek does not show a tolerance field in its dialog, and it does not report a formal accuracy guarantee. Treat its output as a candidate solution, then test the residual at the precision your task requires.

How Goal Seek works

Goal Seek needs a formula cell, a target value, and one changing cell. In Microsoft 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 in By changing cell. The set cell must contain a formula that depends, directly or indirectly, on the changing cell.

For example, a business might want to know what sales amount produces a specified commission. Goal Seek tries a value in the sales input, recalculates the commission formula, compares the result with the requested commission, and adjusts the input. It repeats this process until it meets its stopping conditions or cannot find a suitable result. It is a numerical search, not an algebra solver that proves a unique exact answer exists.

Goal Seek changes only one input at a time. If a formula depends on several unknowns, or if you need constraints such as a minimum input or whole-number values, the Solver add-in is generally more suitable. Goal Seek also depends on the starting value and the shape of the formula, so different starting values can lead to different outcomes for formulas with multiple possible solutions.

The 0.001 setting and its limits

Excel’s calculation options include Maximum Change, whose default value is commonly 0.001, and Maximum Iterations, commonly 100. Maximum Change is a convergence setting associated with iterative calculations. It is often described as controlling Goal Seek precision, but it should not be interpreted as a promise that the target formula’s final residual will be no larger than 0.001. It is not a tolerance you can set separately for every Goal Seek run.

On Windows, find these options at File > Options > Formulas, in the Calculation options area. The settings are workbook-calculation controls, not fields inside the Goal Seek dialog. Changing iteration settings can affect other calculations, particularly workbooks that use circular references and iterative calculation. Record the original values before changing them, and do not enable iterative calculation merely to make a Goal Seek result look more precise unless you understand the effect on the workbook.

Also distinguish calculation precision from number formatting. Showing a result as 1,000.00 only controls how it appears; it does not round the underlying value to exactly 1,000.00. A displayed result can therefore hide a small difference. The reliable check is to create a separate formula that subtracts the target from the actual result and inspect that residual at adequate decimal places.

Check the result with a concrete example

Suppose A2 contains an amount and B2 calculates an 8% commission. With the amount in A2 and the commission formula in B2, enter =A2*8% in B2. If A2 starts at 10000, B2 returns 800. Run Goal Seek with Set cell B2, To value 1000, and By changing cell A2. The exact arithmetic answer is an amount of 12500, because 12500 multiplied by 8% equals 1000.

To measure the difference after Goal Seek, put the requested target, 1000, in C2. With B2 as the actual commission and C2 as the target, enter =B2-C2 in D2. A result of 0 means the values match at the stored precision; a result such as 0.0004 means the commission is four ten-thousandths above the target. For a money task, decide whether that difference matters in the units and rounding rules relevant to your model rather than relying on the display format.

For a more demanding target, repeat the check using the appropriate unit. If the formula returns a percentage, a difference of 0.001 means one-thousandth of a percentage point when the cell stores percentage values as decimals only if interpreted carefully: a stored difference of 0.001 corresponds to 0.1 percentage points. Always translate the residual into the units users will understand.

How to choose a practical tolerance

There is no universal tolerance that is right for every workbook. Choose one based on the meaning of the output, the formula’s sensitivity, and the accuracy of the inputs. A model based on estimates may not justify many decimal places, while a reconciliation that must balance to the cent may need a tighter check.

  • Start with the units. Decide whether the acceptable difference is a fraction of a unit, a cent, a percentage point, or another meaningful amount.
  • Consider rounding rules. If the business result is rounded to whole dollars, a tiny residual below one cent may be immaterial; if a later formula uses unrounded values, it may still matter.
  • Check sensitivity. A small change in the input can create a large output change in a steep formula. Look at both the input and the target-cell residual.
  • Use a stated acceptance test. Keep the residual visible and decide in advance what magnitude is acceptable. Do not silently treat a close-looking number as exact.

For a model that must satisfy a strict acceptance rule, record the chosen threshold in a cell or in the workbook documentation. That makes the check repeatable when assumptions or formulas change.

Common reasons a result is not exact

Goal Seek may stop short or fail to find a useful result for several reasons. The target may be unreachable: for example, a square formula cannot return a negative value for real inputs. A formula with a jump, a threshold, or extensive rounding may not vary smoothly enough for the search to settle reliably. A formula that does not depend on the changing cell cannot respond to Goal Seek at all.

Multiple solutions are another source of confusion. If a formula has more than one input that produces the requested output, Goal Seek may find one solution near its starting point and not another. A result is not necessarily the only possible answer. Try a sensible starting value, inspect the formula’s behavior, and test whether other solutions are relevant.

Check for these issues before repeatedly rerunning the tool:

  • Confirm that Set cell is a formula and that the formula depends on the selected changing cell.
  • Make sure the changing cell contains a reasonable numeric starting value and is not blocked by worksheet protection.
  • Check whether the formula uses rounding, IF thresholds, lookup bands, or other discontinuities.
  • Verify that workbook calculation is set to Automatic if you expect formulas to recalculate as inputs change.

If Goal Seek reports that it could not find a solution, that message does not prove the target is impossible. It can also mean that the search did not converge from the chosen starting point or within its calculation limits. Test the formula at several plausible input values to see whether the target is bracketed and whether the output moves in the expected direction.

Ways to improve reliability

First, use a realistic initial value. If you are solving for a loan payment, for instance, start near a plausible payment rather than at an extreme number. A helpful starting point gives the search a better local view of the formula. If the formula is nonlinear, test values on both sides of the expected answer and note whether the target lies between their outputs.

Second, simplify the model temporarily. Confirm the formula’s dependencies, remove unnecessary rounding from intermediate calculations where appropriate, and avoid embedding hard-to-follow conditions in the cell being solved. Keep a copy of the original workbook before changing model structure. Restore the intended formula and formatting after diagnosing the issue.

Third, verify the answer independently. Recalculate the formula using the candidate input, inspect the residual, and test nearby inputs if a small change could affect the conclusion. If the required tolerance is stricter than Goal Seek can consistently provide, use a method that lets you define and audit a suitable acceptance condition rather than assuming a global calculation setting guarantees it.

Goal Seek versus Solver

Goal Seek is the simpler tool when one formula cell must reach one numeric value by changing one input. Solver is designed for more complex optimization and constraint problems, such as adjusting several cells, limiting them to a range, or maximizing or minimizing an objective. Solver is an Excel add-in and may need to be enabled before it appears on the Data tab.

Solver has options for its solving methods and constraint precision, but those are not the same thing as a Goal Seek tolerance field. If you use Solver to meet a target, express the target requirement as a constraint or as part of the model, then inspect the final result and its residual. The right tool depends on the model: switching to Solver does not automatically make an ill-defined or impossible target solvable.

Frequently Asked Questions

What is the default tolerance for Excel Goal Seek?
Goal Seek has no displayed, per-run tolerance. Excel’s commonly cited default Maximum Change is 0.001, but it is a general calculation convergence setting and should not be treated as a guaranteed maximum difference between the target and final result. Check the residual directly.

Can I change Goal Seek’s tolerance?
There is no tolerance box in the Goal Seek dialog. You can review Maximum Change and Maximum Iterations under File > Options > Formulas on Windows, but these are calculation settings, not a clear per-run residual guarantee. Verify any result against your own acceptance threshold.

Why does Goal Seek say it found a solution when the value is slightly off?
Goal Seek is iterative and can accept a sufficiently close result under its calculation behavior. Formatting can also hide a difference. Subtract the target from the actual formula result in another cell and display enough decimal places to see the residual.

Does increasing Maximum Iterations always make Goal Seek more accurate?
No. More iterations may help a search that needs additional calculation steps, but they cannot make an unreachable target possible or fix a discontinuous formula, an incorrect cell reference, or a poor model. Check the formula and residual as well.

Can I use Goal Seek in Excel for the web?
Goal Seek is a desktop Excel feature; use the Windows or Mac desktop app if the command is unavailable in Excel for the web. The precise menu presentation and calculation-options paths can differ between Windows and Mac versions.

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.