Excel Goal Seek Tutorial: Steps, Examples, and Tips

To use Goal Seek in Excel for Microsoft 365 on Windows, select Data > What-If Analysis > Goal Seek, enter a formula cell under Set cell, the result you want under To value, and one input cell under By changing cell. Select OK to calculate a value for that input. Goal Seek is useful when you know the result you want but need Excel to work backward to find one input that produces it.

What Goal Seek does

Goal Seek is a built-in What-If Analysis tool. Instead of changing an input and observing the result, you specify a desired result and ask Excel to adjust one input until a formula reaches it. For example, you can calculate how many units must be sold to reach a profit target, what test score would produce a particular course grade, or what interest rate would make a payment equal a chosen amount.

It does not write a new formula into your worksheet or create a permanent forecast. It changes the value in the cell you identify as the changing cell, then recalculates the workbook. The result is a numerical answer for that input, based on the formulas and assumptions currently in the workbook. Keep a record of the original input if you may want to return to it later.

Goal Seek is designed for a single target formula and a single changing cell. It can work through formulas that depend on several other cells, as long as changing the selected input affects the formula being targeted. It is not a general optimizer: it cannot vary several inputs together or enforce conditions such as “units must be a whole number” or “the rate must stay below 8%.”

Prepare the worksheet first

Before opening the dialog, build and check the calculation you want Excel to solve. The target cell must contain a formula that returns a number, and the changing cell should contain a numeric input used directly or indirectly by that formula. A label, text entry, or unrelated cell will not work as the variable.

For a simple profit model, use this layout:

B2: units sold, initially 500
B3: selling price per unit, 50
B4: variable cost per unit, 30
B5: fixed costs, 5,000
B6: profit, calculated from the other four cells

With units sold in B2, selling price in B3, variable cost per unit in B4, and fixed costs in B5, enter this formula in B6: =B2*(B3-B4)-B5. At the initial values, the result is 5,000: 500 units each contribute 20, less 5,000 in fixed costs. A clear layout makes it easier to choose the right target and variable and to review the answer afterward.

Step-by-step: find a target value

Confirm the formula cell displays a numeric result. In the profit example, select B6 and verify that its formula and current result make sense.
On the ribbon, select Data > What-If Analysis > Goal Seek. The Goal Seek dialog has three fields.
In Set cell, enter or select the formula cell, B6. This is the cell whose result you want to control.
In To value, type the target number, such as 10000. Enter the number itself rather than a reference to another worksheet cell.
In By changing cell, enter or select B2, the units-sold input. It must be a cell Excel can change, not the formula cell.
Select OK and review the status message and proposed values. Select OK to keep the solution in the worksheet, or Cancel to return without accepting it.

For this example, the answer is 750 units: 750 multiplied by the 20 contribution per unit gives 15,000, and subtracting 5,000 in fixed costs leaves the 10,000 target. Check that B2 now contains 750 and B6 displays 10,000. If the changing value is a fraction where the real-world input must be a whole number, round it appropriately and recalculate the result rather than treating the fractional answer as an executable plan.

How to interpret the result

Goal Seek searches for a value that makes the formula approach the target; it is not proof that the assumptions are realistic. The output is only as useful as the worksheet. If the price, cost, or target in a model is wrong, Goal Seek can still return a mathematically consistent answer that is unsuitable for the situation.

Excel may report that it found a solution even when the displayed result differs slightly from the target. Calculations use numeric precision and an iterative search, so a small difference can occur, especially with complex formulas. Review the result cell and decide whether the difference matters for the task. For money, you may want to format the display to two decimal places, but remember that formatting changes what is shown, not the underlying value.

Goal Seek can also return a solution that is surprising because formulas are nonlinear or because more than one input value can produce the same target. The starting value can influence which solution it finds. Try a different reasonable starting value if the result seems unexpected, and inspect the formula’s behavior across plausible inputs before relying on it.

Useful applications and a related example

Beyond sales targets, Goal Seek can answer straightforward one-input questions in budgeting, operations, education, and planning. Examples include finding the number of attendees needed to cover a fixed event cost, the final exam score needed for a chosen course average, or the quantity required to use a planned production budget. These are calculation examples, not guarantees about future outcomes.

For a grade calculation, suppose a formula cell calculates a weighted course average from an exam score and other fixed grades. If the exam score is the only input to change, set the average formula cell to the desired course average and select the exam-score cell as the changing cell. The formula must already include the exam score with its correct weight. Goal Seek will not infer the grading policy or check whether the requested score is possible under the course rules.

For money-related models, treat outputs as illustrative arithmetic rather than financial, tax, investment, or legal advice. A Goal Seek result does not account for terms or conditions that are absent from the worksheet. Check real loan or account terms with the lender, and consult a qualified professional when you need advice about a financial or tax decision.

Limits, Solver, and other alternatives

Use Goal Seek when one formula has a target and one input can be adjusted. If you need to change several cells at once, compare multiple scenarios, or impose constraints, use a more suitable method. Solver is Excel’s optimization add-in for problems that can involve an objective cell, multiple changing cells, and constraints; it is more flexible but requires setting up a Solver model. Availability and setup can vary by Excel installation.

For a small number of candidate inputs, a data table or a manually prepared scenario list may be clearer than Goal Seek. A data table shows how formula results change as one or two inputs take specified values, which helps when you want to compare a range rather than find one target. For simply substituting a few assumptions across a workbook, Scenario Manager may also be useful. These tools answer different questions; Goal Seek is the direct choice for “what single input gives me this result?”

Goal Seek is available in the desktop Excel app, but it is not available in Excel for the web. If the command is missing or disabled in a browser, open the workbook in desktop Excel. On Excel for Mac, use the Data tab and look for What-If Analysis and Goal Seek; ribbon organization can differ slightly by release. The core three-field process is the same.

Common problems and fixes

“Set cell” is not a formula cell: choose the cell containing the calculation, not a label or input. Confirm the formula depends on the selected changing cell.
The result does not move: check whether the formula actually references the changing cell, including through other formulas. A disconnected input cannot affect the target.
The result is not the one expected: verify units, signs, percentages, and formula references. For example, entering 10 when the model expects 10% can change the meaning substantially.
No useful solution appears: the target may be unreachable for the formula, or the search may be following an unexpected path. Try a sensible initial value and inspect the formula at several plausible inputs.
The answer violates a practical rule: Goal Seek does not enforce bounds, whole numbers, or business rules. Check those conditions yourself, or use Solver if the problem requires constraints.
The worksheet is protected or the input is unsuitable: make sure the changing cell is editable and contains a value Excel can adjust. Unprotect the sheet if you have permission and need to change it.

After accepting a result, consider noting the original input and the target assumptions, particularly in a shared workbook. Goal Seek changes the worksheet’s changing-cell value; it does not preserve a separate record of the assumptions used to produce the answer. You can undo a recent Goal Seek change with the normal Undo command, but saving a copy before major what-if work is a safer way to preserve a baseline.

Frequently Asked Questions

Where is Goal Seek in Excel?
In desktop Excel for Microsoft 365 on Windows, select Data > What-If Analysis > Goal Seek. In Excel for the web, open the workbook in the desktop app to use Goal Seek.

Can Goal Seek change more than one cell?
No. Goal Seek changes one input cell at a time. For a target that depends on multiple adjustable inputs or constraints, consider Solver or compare scenarios with another What-If Analysis tool.

Why does Goal Seek need a formula cell?
The formula cell supplies the result Excel is trying to reach. A value typed directly into a cell cannot recalculate in response to a changed input, so Goal Seek needs a formula that depends on the changing cell.

Can Goal Seek find a whole-number answer?
It can return a decimal value because it does not impose an integer constraint. Round or adjust the input and check the resulting formula value, or use Solver when whole-number restrictions are part of the problem.

Does Goal Seek save the answer as a formula?
No. It places the calculated answer in the changing cell as a value. The target cell remains a formula, and the changing input stays at the accepted result until you change it again.

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.