Excel Goal Seek: Step-by-Step Guide With Examples

Excel Goal Seek answers a question most spreadsheets only hint at: what input value gets you a specific result? Instead of guessing numbers, tweaking cells, and watching the output, you tell Excel the answer you want — and it works backwards to find the input. Think of it as a small built-in solver that handles single-variable problems quickly, without writing a single formula.

You will find Goal Seek tucked inside Data > What-If Analysis, alongside Scenario Manager and Data Tables. It runs on any cell that contains a formula, and it can adjust any cell that feeds into that formula directly or through a chain of references. Mortgage payments, break-even prices, sales targets, exam scores — all classic use cases. If you have ever asked "what rate makes this work?" or "how many do I need to sell to hit $50,000?", Goal Seek was built for you.

This guide walks through everything: where Goal Seek lives in every modern Excel version, the exact dialog box fields, three worked examples, why it sometimes fails, the precision setting hidden in Options, and how Goal Seek compares with Solver. We will also cover keyboard shortcuts, common errors, and the limits you should know before trusting it on important decisions.

What Goal Seek Actually Does

Most spreadsheet work flows in one direction: inputs at the top, formulas in the middle, results at the bottom. Change an input, watch the result update. Goal Seek flips that direction. You fix the result, and Excel adjusts one input until the formula produces that result.

Under the hood, Goal Seek runs a numerical method — a variation of the secant method — to converge on an answer. It tries a value, sees how far off the result is, adjusts, and tries again. After up to 100 attempts (you can change this), it either lands within 0.001 of the target or gives up. Because it only changes one cell, the math stays simple and the calculation is almost instant.

That single-variable limit is the whole reason Goal Seek and Excel Solver coexist. Solver handles many variables, constraints, and complex optimization. Goal Seek handles one variable, no constraints, just "hit this number." If you only need a quick answer, Goal Seek is faster to set up and easier to explain to a manager.

When you should reach for it

Goal Seek shines when there is a clear cause-and-effect chain between one input and one output. Loan payment scenarios are the textbook example: change the interest rate and the monthly payment changes in a predictable way. Same with break-even units, target margins, or the score you need on the final exam to pass.

It struggles, however, when the formula has discontinuities (IF statements that jump in steps), when the relationship between input and output is flat over a range, or when multiple inputs all influence the answer. In those situations, you either rephrase the problem, add a helper formula, or move to Solver.

Where to Find Goal Seek in Excel

The path is the same across every desktop version since Excel 2007. Click the Data tab on the ribbon, then look in the Forecast group near the right side. Click What-If Analysis, and a small dropdown appears with three choices: Scenario Manager, Goal Seek, and Data Table. Pick Goal Seek and the dialog box opens.

Excel for Mac uses the same path: Data > What-If Analysis > Goal Seek. The keyboard shortcut sequence on Windows is Alt, A, W, G. Tapping those keys one after another opens the dialog without touching the mouse. On Mac there is no built-in shortcut, but you can record a macro or assign one through Tools > Customize.

If you use Excel Online through a browser, Goal Seek is missing. Microsoft has not added What-If Analysis to the web version as of 2026, so you will need the desktop app, Excel for Microsoft 365, or a workbook that already contains the macro. The same gap exists in Excel for iPad — what-if tools live on full desktop versions only.

Three fields, every time

The Goal Seek dialog has only three input fields. Set cell takes the address of the formula cell you want to change. To value takes the target number — what you want that formula to equal. By changing cell takes the address of the single input cell Excel is allowed to adjust. All three must point at real cells; you cannot type a constant or a range in "By changing cell", only a single absolute reference like $B$5.

Click OK and Excel runs. A second dialog appears showing the current value and the target value side by side. Click OK again to keep the new input, or Cancel to revert. This pattern — preview first, accept second — saves you from accidental damage when results look wrong.

Walkthrough 1: Mortgage Payment Goal Seek

The classic Goal Seek scenario: you can afford $1,500 a month on a mortgage. The lender has quoted you a 30-year loan. What loan amount fits your budget? Set up a simple worksheet with three input cells and one formula. In B1, type the loan amount as a placeholder, say 200000. In B2, type the annual interest rate, say 6%. In B3, type the loan term in months, 360.

In cell B5, write the PMT formula: =PMT(B2/12, B3, -B1). The result should show $1,199.10 — the monthly payment for a $200,000 loan at 6% over 30 years. Now you want to know what loan amount would push that payment up to exactly $1,500.

Open Data > What-If Analysis > Goal Seek. Set cell: $B$5. To value: 1500. By changing cell: $B$1. Click OK. Excel iterates for a fraction of a second and the loan amount in B1 updates to approximately $250,187. That is the maximum loan you can afford at your budget. Close the dialog with OK to keep the result, or Cancel to revert to your original $200,000.

This same setup works for any payment-rate-term combination. Lock the payment, find the rate. Lock the loan, find the term. Goal Seek does not care which variable you treat as known — as long as one cell feeds into the PMT formula, Excel will solve for it. Just remember the "By changing cell" must be a hard-coded number, not a formula. If you try to point at a calculated cell, Excel refuses with an error.

Walkthrough 2: Sales Target Goal Seek

Sales managers love Goal Seek for one specific question: how many more units do we need to hit the quarterly target? Set up a sheet that tracks units sold per week. In A1:A12, weeks 1–12 of the quarter. In B1:B12, units sold each week. So far, weeks 1–10 are filled in; weeks 11–12 are empty. The total appears in B13 with =SUM(B1:B12).

Your quarterly target is 5,000 units. You have sold 4,100 through week 10. The two remaining weeks need to fill the 900-unit gap, but you also want to know what a single weekly average would look like across those two weeks. In B11, type a placeholder like 50 (this is your changing cell). In B12, type a formula tying B12 to B11: =B11. Now B13 sums everything, including the linked weeks.

Open Goal Seek. Set cell: $B$13. To value: 5000. By changing cell: $B$11. Excel solves: B11 becomes 450, B12 mirrors at 450, and the total hits 5,000 exactly. Your sales team needs to average 450 units per week for the final two weeks to clear the target. Substitute your own targets and the same setup answers the same question every quarter — no formulas to rebuild, no manual trial-and-error.

You can also use a SUM formula with a different layout, where weeks 11 and 12 differ. In that case, point "By changing cell" at one of the two weeks, and let the other carry your assumed value. Goal Seek will still resolve as long as exactly one cell is open for adjustment.

Walkthrough 3: Goal Seek With a Chain of Formulas

Goal Seek does not need the changing cell sitting right next to the set cell. As long as a chain of formulas links them, Excel will trace through the dependency tree. Suppose you have a small profitability model on Sheet1. Cell B1 holds the price per unit. B2 calculates revenue as =B1*1200 (units fixed at 1,200). B3 calculates total variable cost as =14*1200. B4 holds fixed costs of 8,000. B5 calculates profit as =B2-B3-B4.

You want a profit of $10,000. The only variable you can change is price. Open Goal Seek. Set cell: $B$5. To value: 10000. By changing cell: $B$1. Excel works through the chain — adjust B1, recalculate B2, recompute B5 — and lands on a price of about $29 per unit. Even though B1 is two formulas removed from B5, Goal Seek finds the answer without complaint.

Try the same setup with longer chains. Add a sheet that calculates tax, then a sheet that calculates after-tax profit. Point Goal Seek at the final after-tax cell. As long as every link in the chain is a formula and the changing cell is a hard-coded number, Excel will trace it. The only failure mode is breaking the chain with manual data, a paste-special-values, or an external link.

Watch for circular references

If your model has a circular reference — even an intentional one with iterative calculation turned on — Goal Seek behaves unpredictably. It may run forever, fail with a strange error, or return a wrong answer that looks plausible. Always check the Formulas > Error Checking > Circular References menu before running Goal Seek on a complex model. Resolve circulars first, then iterate.

Goal Seek Settings: Iterations and Precision

By default, Goal Seek runs up to 100 iterations and stops when the result is within 0.001 of the target. For most problems that combination is plenty. For tougher problems — fractional rates, tiny target values, very nonlinear formulas — you may need to push those numbers higher. The setting lives at File > Options > Formulas. Look for the Calculation options group near the top.

Tick Enable iterative calculation. Raise Maximum Iterations from 100 to 1,000 if Goal Seek is converging slowly. Drop Maximum Change from 0.001 to 0.00001 if you need a more precise answer. Click OK and rerun Goal Seek. The trade-off is speed — more iterations means slower runs — but for one-off problems the delay is invisible.

The same Options dialog is where you turn on iterative calculation for circular references. Goal Seek and iterative calculation share the same engine. If your model needs both, set them once and you will not need to touch Options again for a while.

What "maximum change" really means

Maximum Change is the precision threshold. When Excel's current guess produces a result that differs from the target by less than this number, it stops and accepts the answer. At the default 0.001, a target of 1,500 will accept any answer between 1,499.999 and 1,500.001. For dollar amounts that is fine. For percentages, it can be too loose — 0.001 means "within a tenth of a percent," and you may need 0.0001 for a tighter fit.

Cranking the precision down does not always help. Some formulas have inherent noise (lookup tables, rounded inputs) and tightening precision just causes Goal Seek to fail because it cannot find a number close enough. Loosen it back if you start seeing "may not have found a solution" messages on problems that should be easy.

Goal Seek vs Solver: Which One Should You Use?

Goal Seek and Solver sit in the same toolkit, but they answer different questions. Goal Seek answers "what value of X makes Y equal Z?" Solver answers "what combination of X1, X2, X3 maximizes (or minimizes) Y, given a list of rules I must follow?" The dividing line is the number of variables and whether constraints matter.

For a single-variable problem with no constraints, Goal Seek wins on speed every time. Open the dialog, fill three fields, hit OK, done. Solver requires installing the add-in (Tools > Excel Add-ins > Solver, or File > Options > Add-Ins on PC), defining variable cells, listing constraints one at a time, choosing a solving method, and waiting for the engine to grind through possibilities. Worth it for hard problems, overkill for simple ones.

A practical rule: if you can describe the problem with one input and one target, use Goal Seek. The moment you start adding rules — "but X must be between 10 and 50" — you have outgrown Goal Seek. Move to Solver or restructure your worksheet so the constraint is built into the formula itself.

Saving and Reusing Goal Seek Scenarios

Goal Seek does not save the inputs you used. The next time you open the dialog, the fields will be empty (or showing the last-used values within the same session). If you run the same Goal Seek often — monthly budget revisions, quarterly forecasts — you have options to make it reproducible.

Record a macro of the Goal Seek run. Developer tab > Record Macro > do the Goal Seek > Stop Recording. You now have a one-click macro that runs the same Goal Seek every time. Assign it to a button on the worksheet and your team can refresh the analysis without opening the dialog. The recorded VBA looks like Range("B5").GoalSeek Goal:=1500, ChangingCell:=Range("B1") — easy to edit if you need to point at different cells.

For more complex needs, build the Goal Seek into a small Sub procedure that prompts the user for the target, runs Goal Seek, and shows the result in a message box. Three or four lines of VBA replace the dialog box entirely and let you embed the logic right inside the workbook.

Final Thoughts on Excel Goal Seek

Goal Seek punches above its weight. Three input fields, one button, and Excel chews through problems that would take dozens of manual edits otherwise. The trick is recognizing the situations where it fits: one input, one target, formulas connecting them. Mortgage math, sales targets, exam scores, break-even analysis — Goal Seek owns these problems and finishes them in a second.

Pair it with a clean worksheet structure and you get a tool you will use weekly. Keep your inputs labeled, your formulas traceable, and your changing cells holding plain numbers. Save before you run. If you outgrow Goal Seek's one-variable limit, the natural next step is Solver — and the muscle memory you build with Goal Seek transfers directly. If you find yourself dropping back to IF statements or INDEX MATCH to wrangle scenarios manually, that is a sign Goal Seek (or Solver) would do the same job in seconds.

Keep an Excel cheat sheet nearby when you start building What-If models. Goal Seek itself is simple, but the formulas you feed it — PMT, NPV, IRR, SUMPRODUCT — reward fluency. The more comfortable you are with those, the broader the range of questions Goal Seek can answer for you, and the less time you spend doing arithmetic in your head before checking it in a spreadsheet.