Excel Goal Seek Precision: Accuracy and Limits

How-to basics · Updated November 19, 2026

Excel Goal Seek can find an input value that makes a formula reach a target, but it does not offer a user-set precision or tolerance in its dialog. In Excel for Microsoft 365 on Windows, choose Data > What-If Analysis > Goal Seek, specify the formula cell and target value, then identify the single input cell Excel may change; check the resulting value rather than assuming it is exact.

What Goal Seek precision means

Precision can refer to several different things: how close the formula result is to the target, how many digits Excel stores, or how many digits a cell displays. These are not interchangeable. A cell formatted to show two decimal places might display 60.00 while storing a value such as 59.9999999. Conversely, a displayed result that looks slightly different from the target may still be close enough for the decision being made.

Goal Seek is an iterative calculation. It changes one input, recalculates the formula, and repeats until it finds a suitable result or cannot find one. Its dialog has no field for an absolute or relative error tolerance. Microsoft does not document a simple precision setting that guarantees a particular number of decimal places for every model. Therefore, treat Goal Seek’s answer as a numerical solution to verify, not as a promise that the formula equals the target exactly.

Excel’s numeric calculations also have finite precision. Excel generally stores numbers using approximately 15 significant decimal digits, and many decimal fractions cannot be represented exactly in binary floating-point arithmetic. Tiny differences can consequently appear in calculations, especially after many operations. That limitation is usually immaterial for ordinary business models, but it matters when a formula includes tight thresholds, very small values, or exact equality tests.

How Goal Seek works in a worksheet

Goal Seek requires a formula cell, a target value, and one changing cell. The formula cell must depend, directly or indirectly, on the changing cell. Goal Seek can vary only one input cell in a single run; it is not a general-purpose optimizer for several independent assumptions.

For example, suppose a simple product model has units sold in A2, price in B2, unit cost in C2, fixed costs in D2, and profit in E2. With those values in place, calculate profit in E2 using =(B2-C2)*A2-D2. If A2 contains 2,500, C2 contains 28, and D2 contains 30,000, a price of 60 produces profit of 50,000: (60 − 28) × 2,500 − 30,000 = 50,000.

  1. Select Data > What-If Analysis > Goal Seek.
  2. Set Set cell to E2, the cell containing the profit formula.
  3. Enter To value as 50000.
  4. Set By changing cell to B2, the price input, then select OK.
  5. Review the result and accept it only if the resulting formula value is sufficiently close for your purpose.

In this example, the exact mathematical price is 60. But a real worksheet may contain more complicated formulas, intermediate rounding, or different starting values. Those details can affect the computed answer, so the example illustrates the method rather than a guaranteed Goal Seek result for every workbook.

How to check the result and its error

Do not judge accuracy solely by the number of digits shown in the changing cell. Check the formula’s actual result and compare it with the target. A residual is the difference between the calculated result and the requested target; a residual of zero means they match in Excel’s stored calculation, while a small nonzero residual quantifies the remaining gap.

In the example layout above, if E2 contains calculated profit and the target is 50,000, put the residual calculation in F2 using =E2-50000. A result of 0 means the stored profit equals the target in that calculation. If Goal Seek leaves B2 at 59.9999999, the profit is 49,999.99975 and the residual is -0.00025, because a price difference of 0.0000001 multiplied by 2,500 units changes profit by 0.00025. Whether that is acceptable depends on the model’s units and intended use.

  • Increase the displayed decimal places temporarily to inspect the changing cell more closely.
  • Read the formula cell’s underlying value, not just its currency or percentage formatting.
  • Calculate the residual in a separate cell and decide in advance what error is acceptable.
  • Recalculate the model after the run and confirm that the input and dependent formulas still make sense.

Formatting changes what you see, not the stored value. The setting called “Set precision as displayed” is a separate workbook calculation option that can permanently discard hidden decimal detail when values are calculated. It is not a Goal Seek accuracy control, and enabling it merely to make a result look rounded can alter other calculations. Keep full precision in the model unless there is a deliberate reason to round the underlying data.

What affects the quality of a solution

Goal Seek works most predictably when the formula changes smoothly as its input changes and a suitable solution lies near the starting value. A formula that rises steadily with price, for instance, is easier to solve than one that jumps between discrete outcomes. The underlying relationship, not just Excel’s calculation engine, determines whether a useful result can be found.

  • Starting value: A poor starting input can make an iterative search struggle, particularly in a nonlinear model. Try a reasonable initial estimate and run Goal Seek again if the first result is implausible.
  • Formula shape: IF statements, lookup bands, thresholds, and stepwise pricing can create jumps or flat regions. The target might fall between attainable outputs.
  • Multiple solutions: A curved formula can reach the same target at more than one input. The result can depend on the initial value, so examine the model and test other plausible starting points.
  • Rounding inside formulas: ROUND or integer conversions can make the output change in steps. A target between those steps may have no exact solution.
  • Calculation mode and dependencies: The formula must update when the changing cell changes. Check that the model is not using stale values or depending on an unrelated cell.

One common misconception is that adding decimal places to a cell will make Goal Seek more accurate. It only reveals more of the stored result. Another is that rounding the final display proves the target was met: a value displayed as 50,000 may actually be 49,999.6. A residual check resolves that ambiguity.

Precision settings and Excel versions

Goal Seek’s own dialog does not expose a precision or tolerance box. Excel’s maximum iterations and maximum change options are associated with iterative calculation, particularly calculations involving circular references. They should not be treated as a dependable way to request a specific Goal Seek tolerance. If a result is inadequate, inspect the formula, starting value, attainable outputs, and residual rather than changing unrelated calculation settings.

These instructions are for Excel for Microsoft 365 on Windows. In current desktop Excel for Mac, Goal Seek is also available from the Data tab’s What-If Analysis controls; ribbon placement can vary with the window and version. Excel for the web does not provide the desktop Goal Seek command, so open the workbook in the desktop application to run it. The workbook can still be viewed and edited in the browser, but that is not the same as running Goal Seek there.

When Solver is a better choice

Goal Seek is appropriate when there is one target formula and one input to change. Use Solver when the model needs multiple changing cells, constraints such as minimum or maximum values, or an objective to maximize or minimize rather than simply match a specified number. Solver is an Excel add-in and offers options for controlling its solving process, but it also requires a suitable model and does not make an ill-defined or discontinuous problem automatically solvable.

For the product example, Goal Seek can find a price that gives a specified profit if price is the only variable. If the question instead asks for a mix of price, production volume, and advertising spend that maximizes profit while respecting capacity and budget limits, the problem has multiple decision variables and constraints. Solver is designed for that kind of task. A data table is useful for comparing many chosen input values and their outputs, but it does not itself search for the input that reaches a target.

Practical ways to improve reliability

Before running Goal Seek, make the model easy to inspect. Keep assumptions in clearly identified input cells, keep the target formula separate from labels, and avoid hard-coding assumptions inside a long formula where they are difficult to check. Save a copy before changing an important model, particularly if the result will be used in a report or operational decision.

  • Start with a sensible input estimate and verify the target is within the range the model can produce.
  • Temporarily remove unnecessary rounding from intermediate formulas, then assess whether rounding is required by the real-world model.
  • Run the calculation from more than one reasonable starting value if the formula is nonlinear or could have multiple roots.
  • Record both the resulting input and the residual, along with the model assumptions that produced them.
  • Use Solver or a transparent manual search when constraints, multiple inputs, or discontinuous outcomes make Goal Seek unsuitable.

For money calculations, distinguish a mathematically tiny residual from a meaningful business difference. A fraction of a cent in a per-unit price can become a larger amount across a very high volume, while a small difference in a percentage may have little practical impact. Use the model’s units and decision requirements to set an acceptable tolerance; do not infer that tolerance from the display format.

Frequently Asked Questions

How many decimal places does Excel Goal Seek use?
There is no decimal-place setting in the Goal Seek dialog. Excel calculates with finite numeric precision, and the number of displayed decimal places is controlled by cell formatting. Check the target formula and its residual to assess the result.

Can I make Goal Seek more precise?
Not by entering a precision value in Goal Seek; the dialog has no such control. Improve the model, use a sensible starting value, avoid unnecessary rounding in intermediate calculations, and measure the remaining difference from the target. Solver may suit problems that need more controls or several changing cells.

Why does Goal Seek stop short of the target?
The target may be unattainable, the formula may jump over it, or the iterative search may not converge from the chosen starting value. Check for rounding, thresholds, flat sections, and multiple possible solutions, then inspect the residual and try a plausible alternative starting value.

Does adding decimal places make the answer more accurate?
No. Increasing displayed decimal places reveals more of the stored number but does not change the calculation. To evaluate the gap, subtract the target from the formula result in a separate cell and decide whether that difference is acceptable.

Can Goal Seek change more than one cell?
No. Each Goal Seek run changes one input cell to make one formula cell reach a target. For multiple changing cells or constraints, use Solver; for comparing a range of selected inputs, consider a data table.

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.