Goal Seek in Excel: How to Find a Target Value

How-to basics · Updated November 21, 2026

In Excel for Microsoft 365 on Windows, open Data > What-If Analysis > Goal Seek. Choose a formula cell under Set cell, enter the result you want under To value, and choose one input cell under By changing cell; Excel calculates the input needed to reach that result.

What Goal Seek does

Goal Seek is Excel’s built-in tool for working backward from a desired result. Instead of entering an input and calculating the outcome, you specify the outcome you want and let Excel adjust one input to find a value that makes the formula produce it. It is useful when you know the target but do not know the exact input required.

For example, a business might know its fixed costs, selling price, and variable cost per unit, then ask how many units it must sell to reach a particular profit. A student might know the current grades and weights in a course and ask what score is needed on a final exam to reach a target overall grade. A borrower could use it to explore a payment or rate in an illustrative worksheet, while remembering that a lender’s actual terms and calculations may differ.

Goal Seek changes a single worksheet cell. That cell must be an input used, directly or through other formulas, by the formula in the result cell. Goal Seek does not build the formula for you, decide which assumptions are appropriate, or guarantee that a useful solution exists.

How the three Goal Seek fields work

The Goal Seek dialog has three fields, and each has a distinct job:

  • Set cell: The cell containing the formula whose result you want to target. It cannot be a fixed value with no formula.
  • To value: The result you want that formula to return. Enter a numeric target, such as 3000 or 0.5.
  • By changing cell: The one input cell Excel is allowed to adjust. It should contain a value, not a formula, and the Set cell formula must depend on it.

For instance, if C8 calculates monthly profit and B3 contains the number of units sold, you could set C8 to a target profit and let Goal Seek change B3. Excel tries values in B3 and recalculates the workbook until C8 is close to the requested target. The rest of the worksheet’s inputs remain as they were.

The target is not a formula to solve symbolically. Goal Seek works through repeated recalculation, so its result is a numerical estimate based on the workbook’s formulas and current values. It is designed for one unknown input, not for changing an entire range of assumptions at once.

Example: calculate the sales needed for a profit target

Suppose a worksheet uses these assumptions: selling price per unit is $25 in B2, variable cost per unit is $15 in B3, fixed costs are $2,000 in B4, and the estimated number of units is 100 in B5. In this layout, enter the following formula in B6 to calculate profit:

With selling price in B2, variable cost in B3, fixed costs in B4, and units in B5, put =(B2-B3)*B5-B4 in B6. At 100 units, the calculation is ($25 − $15) × 100 − $2,000, or a loss of $1,000.

Now suppose the target is $3,000 profit. On Windows, select Data > What-If Analysis > Goal Seek, then enter B6 for Set cell, 3000 for To value, and B5 for By changing cell. Click OK. Excel should return approximately 500 in B5. The arithmetic checks out: ($25 − $15) × 500 − $2,000 = $3,000.

This example also shows why the formula and assumptions matter. If fixed costs were entered as a positive contribution instead of a cost, the answer would be wrong even if Goal Seek completed successfully. Check that units are consistent, that costs and revenues have the intended signs, and that the result formula represents the question you mean to ask.

How to run Goal Seek step by step

  1. Build and check the worksheet formula that calculates the result. Confirm that changing the proposed input cell changes the result.
  2. Select the formula cell or open the tool first; either way, identify the correct cell address for Set cell.
  3. On the ribbon, choose Data > What-If Analysis > Goal Seek.
  4. Fill in Set cell, To value, and By changing cell. Use a cell reference for the first and third fields, and a numeric value for the target.
  5. Click OK and review the status message and the updated worksheet value. Choose OK to keep the result or Cancel to restore the values from before the attempt.

It is sensible to note the original input before starting, particularly in a workbook where the value is important. Goal Seek writes its answer into the changing cell; it does not automatically preserve a separate record of the old assumption or create a named scenario. You can copy the worksheet first or record the original value if you need a clear audit trail.

Understanding and checking the result

A successful Goal Seek message means Excel found a value that brings the formula close to the target; it does not certify that the model is correct or that the answer makes practical sense. Inspect the changing cell and recalculate or evaluate the result cell. In the example, if the returned unit count is around 500, substitute it into the profit calculation and confirm the result is around $3,000.

Small discrepancies can occur because calculations use finite precision. A target of exactly zero, for example, may produce a very small positive or negative number rather than a displayed zero. Cell formatting can also hide decimals: a result displayed as 3,000 may actually be 2,999.97. Increase the displayed decimal places or inspect the formula bar when precision matters.

Consider whether the answer is valid within the real problem. A model may return a fractional number of products, a negative quantity, or a price outside an allowed range. Goal Seek does not apply practical constraints such as whole units, a minimum price, or a maximum budget. Those limitations need to be checked separately or handled with an appropriate optimization tool.

Common problems and how to fix them

  • The Set cell is not a formula. Put the calculation in a formula cell and use that cell as the target. A constant value cannot respond to a changed input.
  • The changing cell does not affect the formula. Check cell references and confirm the result formula depends on the selected input. If the formula points to another cell, changing an unrelated cell will not help.
  • Excel cannot find a solution. The target may be impossible for the model, or the formula may have a restricted range. Test reasonable input values manually to see whether the result moves toward the target.
  • The result is unexpected. Check signs, units, rounding, and whether the formula includes all the intended costs or conditions. Goal Seek follows the formula exactly, including mistakes in it.
  • The result varies or seems unstable. Formulas with jumps, thresholds, lookup bands, or other discontinuities may not behave smoothly as the input changes. A target may fall in a gap that no input can reach.
  • The tool is unavailable. Confirm that you are using the desktop Excel application and look on the Data tab. In Excel for the web, Goal Seek may not be available; open the workbook in desktop Excel for this task.

Another common misconception is that Goal Seek can choose several input cells. It cannot: its By changing cell field accepts one cell. If several assumptions need to vary together, a different method is needed. Also, Goal Seek does not save a collection of possible answers automatically. If comparing cases, record each result or use a scenario-oriented feature.

Goal Seek compared with Solver and data tables

Goal Seek is the simplest choice when there is one target formula and one input to adjust. It is quick to set up and does not require enabling an add-in. Its limitation is deliberate: it changes only one variable and does not let you specify formal constraints such as requiring an input to be an integer or remain below a limit.

Solver is intended for more involved optimization problems. It can adjust multiple variable cells and can apply constraints, such as nonnegative values or a fixed capacity. That makes it more appropriate when the question is not merely “what input reaches this result?” but “which combination maximizes or minimizes an objective while obeying these restrictions?” Solver is a separate Excel add-in in desktop Excel and may need to be enabled through File > Options > Add-ins.

A one-variable or two-variable data table serves a different purpose: it shows how a formula’s result changes across a series of trial inputs. It is useful for comparing many possibilities at once, whereas Goal Seek searches for an input corresponding to one specified target. Choose based on the question: find one input, optimize under constraints, or compare a range of cases.

Excel versions and platform notes

The instructions above are for Excel for Microsoft 365 on Windows. In desktop Excel for Mac, Goal Seek is also available from the Data tab, generally under What-If Analysis; ribbon labels or placement can vary slightly by release. If you cannot locate it, use Excel’s command search or check the Data tab in the desktop app.

Excel for the web has fewer what-if analysis tools than desktop Excel, and Goal Seek may not be offered there. If the command is missing, choose Open in Desktop App and run the analysis in the Windows or Mac application. After saving, the changed cell value and formulas can be viewed in the workbook as usual.

Goal Seek does not require a special worksheet function or an add-in in desktop Excel. It is a command that changes a cell value and recalculates the formulas already in the workbook. The worksheet’s calculation mode and formula structure can affect how promptly results update, so check that calculation is set appropriately if formulas appear not to recalculate.

Frequently Asked Questions

Where is Goal Seek in Excel?
In desktop Excel for Windows, go to Data > What-If Analysis > Goal Seek. In desktop Excel for Mac, look on the Data tab for What-If Analysis and Goal Seek. The command may not appear in Excel for the web.

Can Goal Seek change more than one cell?
No. Goal Seek adjusts one cell in its By changing cell field. Use Solver when the model requires multiple changing cells or constraints.

Why does Goal Seek need a formula cell?
It needs a calculated result to compare with the target. The formula cell must depend on the input cell that Excel is allowed to change; otherwise changing that input cannot affect the target.

Does Goal Seek change the workbook permanently?
It changes the value in the selected input cell when you accept the result. You can undo the change or restore the original value, but record the starting assumption if you need to compare or document scenarios.

Can I use Goal Seek to find a break-even point?
Yes. If a formula calculates profit or net cash flow, set that formula cell to 0 and let Goal Seek change the relevant input, such as units sold. Confirm that zero is reachable and that the resulting input makes sense for the model.

Why is Goal Seek’s answer not a whole number?
Goal Seek searches for a numeric value and does not impose integer restrictions. If the input represents countable items, round or test a suitable whole-number value and recalculate the formula; use Solver if integer constraints must be enforced.

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.