Last updated August 2026. Goal Seek works a formula backwards. You tell Excel the answer you want, point it at the one input it is allowed to change, and it hunts for the value that gets there. Open it from Data > What-If Analysis > Goal Seek, fill in three boxes, and you have the loan amount that hits your target payment or the price that clears your margin, without guessing at the input and re-checking twenty times.
It is one of the oldest features in Excel and one of the least used, mostly because people find it once, hit an error, and never come back. The errors are predictable and the fixes take seconds. Here is the whole tool, including where it stops being the right answer.
How do I use Goal Seek in Excel?
Select the cell that holds the formula you want to hit a specific result, then go to the Data tab and, in the Forecast group, click What-If Analysis and choose Goal Seek. Fill in the three fields and click OK. Excel iterates until the formula returns your target and writes the answer into the input cell. On a Mac the path is the same, minus the Forecast group.
| Field | What goes in it | The rule people break |
|---|---|---|
Set cell | The cell containing the formula you want to resolve | It must contain a formula, not a typed number |
To value | The formula result you want | It must be a number you type, not a cell reference |
By changing cell | The cell holding the input Excel may adjust | It must be a plain value, and the Set cell formula must depend on it |
That third rule is the one worth memorizing. Microsoft states it directly: the cell that Goal Seek changes must be referenced by the formula in the cell you named in the Set cell box. If there is no chain of dependency between the two, Excel has no lever to pull and nothing will happen.
What is a Goal Seek example?
Say you are sizing a loan. Cell B1 holds the loan amount, B2 the annual rate, B3 the term in months, and B4 the payment: =PMT(B2/12, B3, -B1). You know the property can support a payment of $9,500 a month and you want to know what that borrows.
Set cell B4, To value 9500, By changing cell B1. Click OK and B1 becomes the loan amount whose payment is exactly $9,500. The same setup answers the reverse question if you change which cell moves: fix the loan and change B2 to find the rate at which the deal stops working.
The pattern generalizes to most of the questions people actually bring to a spreadsheet. What revenue do I need for a 15 percent net margin? What occupancy covers the mortgage? What unit price recovers my fixed costs at this volume? Each is one formula and one input, which is exactly Goal Seek's shape. If you are building the loan side of this, our guide to building an amortization schedule in Excel covers the payment mechanics, and calculating DSCR in Excel covers the coverage test the payment has to satisfy.
Why is Goal Seek not working?
Almost every failure is one of five things, and none of them are subtle once you know to look.
| Symptom | Cause | Fix |
|---|---|---|
| Nothing changes, or Excel says it cannot find a solution | The changing cell is not referenced by the Set cell formula | Trace the formula. The input must feed the result, directly or through other cells |
| Goal Seek refuses the changing cell | That cell contains a formula, not a value | The changing cell must be a hard number Excel is free to overwrite |
| Error on the Set cell | It holds a typed constant | The Set cell has to be a formula. There is nothing to solve otherwise |
| It lands close but not exactly on target | Goal Seek stops when it is near enough, by design | Tighten Maximum Change under File > Options > Formulas, or accept the rounding |
| It runs and returns something absurd | No real solution exists, so it wandered | Check the answer makes sense. A negative price means your target was unreachable |
The last row deserves emphasis because it fails quietly. Goal Seek is a numerical search, not an algebra engine. Ask it for a 60 percent margin on a cost base that cannot produce one and it will not tell you the goal is impossible. It will hand back whatever it drifted to when it gave up. Always read the result before you act on it.
Can Goal Seek change more than one cell?
No. Microsoft's own documentation is explicit that Goal Seek works with only one variable input value. One formula, one target, one cell it is allowed to move. That single-variable limit is the tool's defining constraint and the reason it is so quick to set up.
The moment your question involves two levers, or any constraint at all, you have outgrown it. That is Solver's job.
What is the difference between Goal Seek and Solver?
Solver is a separate add-in that solves the same class of problem with far more room. It can change many cells at once, respect constraints such as keeping headcount a whole number or holding spend under a cap, and optimize for a maximum or minimum rather than one exact target.
| Goal Seek | Solver | |
|---|---|---|
| Cells it can change | One | Many |
| Constraints | None | Yes, including integer and binary |
| Objective | An exact target value | Maximum, minimum, or a target value |
| Setup | Three boxes, a few seconds | A proper model definition |
| Availability | Built in | An add-in you enable first |
Solver ships with Excel but is switched off by default. Turn it on under File > Options > Add-ins, choose Excel Add-ins in the Manage box, click Go, and tick Solver Add-in. It then appears in the Analyze group on the Data tab. Use Goal Seek when the question is what input gives me this exact number, and Solver when it is what mix of inputs gives me the best outcome without breaking these rules.
What is What-If Analysis in Excel?
What-If Analysis is the menu Goal Seek lives under, and it holds three tools that answer three different shapes of question.
- Goal Seek works backwards from one answer to one input.
- Data Table works forwards, recalculating a formula across a whole grid of one or two input values at once. This is what you want for a sensitivity table showing IRR across a range of exit multiples and hold periods.
- Scenario Manager stores named sets of inputs, such as base, upside, and downside, and lets you flip between them and print a summary.
A data table is the one most people should use more. Goal Seek gives you a single point answer, and a point answer hides how sensitive the result is. Seeing that your return holds up across a band of exit assumptions is usually worth more than knowing the exact multiple that hits your target. When you are working through the return math itself, our guides to calculating IRR in Excel and calculating NPV in Excel cover the formulas these tools drive.
How do I undo Goal Seek?
Goal Seek overwrites the changing cell with its answer, so your original input is gone the moment you click OK. Ctrl + Z puts it back, and the Goal Seek Status dialog offers Cancel before you commit, which leaves the sheet untouched.
The habit worth building on a model you care about is copying the input to a spare cell first, or running Goal Seek on a duplicate of the tab. Once you have closed and saved the file, the number it replaced is not recoverable.
Using Goal Seek on numbers you converted from a PDF
This is where Goal Seek trips people up for a reason that has nothing to do with Goal Seek. If your figures came out of a bank statement, an operating statement, or a financial exhibit that started life as a PDF, some of them may be sitting in the sheet as text rather than numbers. Text that looks like a number breaks the formula chain silently: the formula returns 0 or an error, Goal Seek has nothing coherent to solve, and the tool takes the blame.
The tell is alignment. Numbers align right by default and text aligns left, so a column of figures hugging the left edge is text. Our guide to converting text to numbers in Excel covers the fixes, and the wider cleanup checklist after a PDF conversion catches the rest. Getting a clean extraction in the first place saves the step: our operating statement converter and income statement converter keep the figures numeric on the way in, and deal teams working through a data room can convert whole exhibit sets with PDF to Excel for private equity.
One more caution specific to modeling. Goal Seek will happily solve against a number you extracted wrong. Before you work backwards from a target, confirm the converted subtotals still foot to the printed ones. Working backwards from a bad input produces a confident, precise, wrong answer, which is worse than an obvious error. If you are backing into a purchase price this way, it is worth sanity checking the result against an independent estimate of what the business is worth before the number hardens into a bid.
The short version
Goal Seek answers one question well: what value in this cell makes that formula equal this number? Open it from Data > What-If Analysis, remember that the Set cell must hold a formula and the changing cell must feed it, and check that the answer is sane before you use it. When you need two variables, constraints, or an optimum rather than a target, switch to Solver. When you want to see the shape of the sensitivity rather than one point on it, build a data table instead.