excelavon

Goal Seek Cell Must Contain Value Error in Excel

Errors & fixes · Updated November 3, 2026

Goal Seek Cell Must Contain Value Error in Excel

In Excel, the Goal Seek message “Cell must contain a value” usually means the cell in the By changing cell box is blank or does not contain a usable numeric input. Enter a number in that cell, make sure the formula in the Set cell depends on it, and try again; the Set cell itself must contain a formula, not a fixed value.

What the Goal Seek error means

Goal Seek works backward from a result you want. You choose a formula cell, specify the result it should reach, and identify one input cell Excel is allowed to change. The error points to a problem with the input-cell selection or contents: Excel needs a starting value it can adjust while recalculating the formula.

For example, a genuinely empty changing cell may be treated as zero in some spreadsheet calculations, but Goal Seek may still reject it as an input. Put an explicit number in the cell, even if that number is 0, then run Goal Seek again. A number stored as text, a label such as “unknown,” or a cell containing an error is not a dependable numeric starting value.

The wording can vary slightly with Excel version or context. The important distinction is that the changing cell is an input, while the Set cell is the formula that produces the result. Each has a different requirement.

How Goal Seek is supposed to be set up

In Excel for Microsoft 365 on Windows, open Data > What-If Analysis > Goal Seek. The dialog has three fields:

  • Set cell: Select one cell containing a formula whose result you want to reach.
  • To value: Type the target result as a number, such as 500 or 0.15.
  • By changing cell: Select one input cell with a value that Excel can vary. The Set cell’s formula must depend on this input, directly or through other formulas.

Click OK to let Excel search for an input that gets the formula result close to the target. If it finds a solution, Excel shows the Goal Seek Status dialog. Choose OK to keep the changed value or Cancel to restore the previous value.

On Excel for Mac, Goal Seek is also available from the Data tab, under What-If Analysis in versions that show that command. Excel for the web does not provide the desktop Goal Seek dialog; open the workbook in the desktop app to use it. Menu presentation can vary between releases, but the three required roles—formula, target, and input—are the same.

Fix the changing cell step by step

  1. Close the error message and inspect the cell address in By changing cell.
  2. Click that worksheet cell. Enter a sensible numeric starting estimate, such as 1, 100, or 0, and press Enter. Do not type a descriptive word or an apostrophe before the number.
  3. Check that the cell is not itself a formula. Goal Seek needs to change an input value, rather than overwrite a formula that calculates another result.
  4. Reopen Goal Seek and confirm the Set cell contains the formula you intend to solve, the target is numeric, and the changing-cell address is correct.
  5. Run Goal Seek. If it reports that it could not find a solution, troubleshoot the model separately; that is different from the missing-value error.

A cell formatted as Currency, Percentage, or Number can still hold a numeric value; formatting alone does not cause this error. The underlying cell content matters. For instance, a cell displaying $25.00 may contain the number 25, which is valid. A cell displaying 25 that was imported or entered as text may not behave as a numeric input.

A worked example: solve for a required price

Suppose A2 contains a starting price of 100 and the goal is to make a result in B2 equal 162 after applying an 8% increase. With the starting value in A2, enter this formula in B2: =A2*1.08. At the initial price of 100, B2 calculates to 108.

Now open Goal Seek and set the fields as follows: Set cell B2, To value 162, and By changing cell A2. Excel changes A2 to 150, because 150 multiplied by 1.08 is 162. The result is easy to verify: the target is reached exactly in this example. If A2 were blank, entering a starting value such as 100 first would prevent the missing-input problem and give Goal Seek a meaningful place to begin.

This example also shows why the changing cell must affect the formula. If B2 instead contained a hard-coded 108, changing A2 would not alter B2. Goal Seek could not solve the relationship, even if A2 contained a valid number. A valid input cell and a connected formula are both necessary.

Other setup problems that resemble this error

Some Goal Seek failures are caused by a different field or by the structure of the worksheet. Check these common cases before changing a working model:

  • The Set cell is a constant or blank. Set cell must be a formula cell. If it contains a manually typed result, Excel has nothing to recalculate toward the target.
  • The target was entered as text. Type a numeric target in To value. A label such as “break even” belongs in a worksheet label cell, not in the target field.
  • The changing cell is not connected to the formula. Trace the formula’s references. If the selected input cannot affect the Set cell, Goal Seek has no meaningful variable to adjust.
  • The selected cell contains a formula. Choose the underlying assumption or input cell instead. Goal Seek changes one cell; it should not replace a calculation in the model.
  • The formula has no feasible answer. For instance, if a formula can only return positive results, asking it to reach a negative target may be impossible. A failed search is not necessarily a cell-value error.
  • The formula has a discontinuity or a flat region. Rounding, IF logic, lookup bands, and thresholds can make small input changes produce no change—or a sudden jump—in the result. Goal Seek may have difficulty finding a value near such boundaries.

Also check that workbook calculation is enabled and that the formula does not already return an error such as #VALUE! or #DIV/0!. Fix formula errors first. If the model uses external data, confirm that the relevant inputs and formulas have updated before relying on the result.

Why the starting value and formula design matter

Goal Seek is a numerical search, not a symbolic algebra tool. It repeatedly changes the input and recalculates the formula, aiming to make the output approach the target. A reasonable starting estimate can help it find an appropriate result, especially when the formula is nonlinear or has more than one possible solution.

Consider a formula that has two different inputs producing the same target. Goal Seek changes only one cell and starts from its current value, so it may converge on one solution rather than another. If the result is surprising, try a different plausible starting value and inspect the formulas. Do not assume that a successful status proves the result is unique or appropriate for your model.

Keep the model transparent: put assumptions in input cells, calculations in formula cells, and labels beside them. Avoid using a rounded display value as proof that the target is exact; a cell may display 10.0 while storing a value slightly above or below 10. Use the formula bar or increase displayed decimal places to inspect the result when precision matters.

Goal Seek compared with Solver and manual calculation

Goal Seek is suited to a straightforward question with one target formula and one changing input. It is built into Excel and is useful for tasks such as finding a required sales quantity, price, or rate in a worksheet model. It does not let you specify multiple changing cells or add constraints such as “the input must be an integer between 1 and 100.”

Excel Solver is the better fit when a problem needs multiple variable cells, constraints, or an objective that must be maximized or minimized. Solver is an add-in, and availability or setup may differ by Excel installation. For a simple one-input equation, a direct algebraic rearrangement or a formula may be clearer than either tool. These options do not change the basic diagnosis: the specific “cell must contain a value” message calls for checking the changing input cell first.

Frequently Asked Questions

Does the Goal Seek changing cell have to contain a number?
Yes. It should contain a usable numeric starting value that Excel can adjust. If it is blank, enter a number such as 0 or a reasonable estimate, then run Goal Seek again.

Can the Set cell be a number instead of a formula?
No. Set cell needs a formula whose result can change when the input changes. A fixed number cannot respond to Goal Seek.

Why does Goal Seek say it cannot find a solution after I enter a value?
That usually indicates a different issue: the chosen input may not affect the formula, the target may be unreachable, or the formula may be difficult for a numerical search. Check the cell references and test whether plausible input changes move the result toward the target.

Can Goal Seek change more than one cell?
No. Goal Seek adjusts one changing cell at a time. Use Solver when your model requires multiple changing cells or constraints.

Is Goal Seek available in Excel for the web?
The desktop Goal Seek dialog is not available in Excel for the web. Open the workbook in Excel for Windows or Mac and use the Data tab’s What-If Analysis commands where available.

Quick checklist before trying again

For the specific value error, start with the By changing cell field: confirm that it points to the intended cell and that the cell contains a numeric starting value rather than a blank, text, error, or formula. Then verify that the Set cell is a working formula and actually depends on that input. Finally, enter a numeric target and run Goal Seek again. These checks separate a simple missing-input problem from a model that is validly set up but cannot reach the requested result.

Related

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.