Goal Seek in Excel finds the input value that makes a formula return the result you want: choose Data > What-If Analysis > Goal Seek, enter the formula cell, the target value and the one input cell Excel may change, then click OK. It solves for a single variable only; for several variables use Solver. Practice with the free Excel practice test on PracticeTestGeeks (500+ questions with answer explanations).
Goal Seek is the answer to a question most spreadsheet users ask sooner or later: "I know the result I want — what input gets me there?" Instead of guessing values until a formula returns the right number, you tell Excel the target, point it at the cell that needs to change, and let the engine iterate until it lands on the right input.
It lives quietly inside the What-If Analysis menu on the Data tab. Most beginners walk past it for years. That is a shame, because the moment you understand Goal Seek, a long list of "let me try a different number" problems collapses into a three-field dialog box. Loan payments, profit targets, break-even points, grade calculations, pricing scenarios — all of them get easier.
This guide walks through every part of the feature: where it sits, the exact steps to run it, four real examples you can copy, the limits you need to know about, and what to do when Excel says Goal Seek did not find a solution. By the end you will be comfortable enough to reach for it without thinking.
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
| Item | Detail | Official source |
|---|---|---|
| Number of questions (Excel Associate (MO-210)) | 33-37 questions | certiport.pearsonvue.com |
| Number of questions (Excel Expert (MO-211)) | 23-27 questions | certiport.pearsonvue.com |
| Time limit | 50 minutes (60 minutes seat time) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Passing score | 700 on a 1–1000 scale | certiport.pearsonvue.com |
| Retake policy | Wait 24h after 1st fail, 48h before each later retake; no annual limit | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Validity | Valid 5 years (earned on/after Sept 23, 2025) | certiport.pearsonvue.com |
| Delivery | Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Eligibility | No formal prerequisites; about 150 hours of instruction and hands-on experience recommended | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Score release | Score report at end of exam; also in Certiport profile | certiport.pearsonvue.com |
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
Interactive Excel resources on PracticeTestGeeks, free to start:
Goal Seek is a single-variable solver built into Excel. Give it three things — a formula cell that holds your output, the number you want that formula to produce, and one input cell it is allowed to change — and it works backward until the output matches your target. That is the entire mental model.
Compare it to how you would normally use a spreadsheet. Forward-direction thinking sounds like "if I sell 200 units at $40 each my revenue is $8,000." Goal Seek flips that around: "I need $10,000 in revenue and my price is fixed at $40, so how many units must I sell?" Same formula, different question.
You will reach for it whenever the answer matters more than the input. Some common moments:
If those questions feel familiar, you have been doing Goal Seek by hand. The feature just automates the trial and error. Curious how Excel pulls this off so quickly? Microsoft describes Goal Seek and Solver as tools that use iteration in a controlled way to reach a result, so the answer is approximated, not derived algebraically. That distinction matters for the limits section later.
Goal Seek lives in the same place across every modern desktop version of Excel — 2016, 2019, 2021, Microsoft 365, and the standalone 2024 release. The path is:
Data tab → Forecast group → What-If Analysis → Goal Seek
On smaller screens the Forecast group sometimes collapses into a single icon. Click it and the dropdown reveals What-If Analysis. Inside that dropdown you will see three options: Scenario Manager, Goal Seek, and Data Table. Goal Seek is the middle one.
Mac users follow the same Data tab path; Microsoft documents Goal Seek for Excel for Microsoft 365, 2024 and 2021 on Mac. Microsoft's Goal Seek instructions cover only the Windows and macOS desktop apps, so Excel for the web users should open the workbook in the desktop app. The Solver add-in is not an alternative in a browser either, because Microsoft states add-ins are not supported in Excel for the web (using Solver requires desktop Excel).
On Windows, a faster route is the keyboard sequence Alt, A, W, G, which opens the dialog without the mouse.
You should see three input fields when the dialog opens:
Three fields. That is the whole interface. The simplicity is the point.
On Windows, press Alt, A, W, G in sequence to open Goal Seek without the mouse. On Mac, use the Data tab menu (Data > What-If Analysis > Goal Seek).
Let us walk through a basic example. Imagine you sell handmade candles at $24 each. You have $1,200 in monthly fixed costs and your variable cost per candle is $9. Profit equals revenue minus total costs. Build the sheet first:
With 100 units, B5 shows $300 profit. Now you want $2,000 in monthly profit. How many candles must you sell? Rather than typing 110, 130, 150 until you see $2,000, open Goal Seek.
Click on B5 first — selecting the output cell beforehand pre-fills the dialog. Then go to Data → What-If Analysis → Goal Seek. The three fields populate:
Hit OK. Within a fraction of a second a small dialog appears: Goal Seek found a solution. Target value: 2000. Current value: 2000. Cell B4 now reads 213.333, and B5 reads exactly 2000. You need roughly 214 candles a month to hit that profit goal.
Two buttons appear in the result dialog. OK keeps the new values in your sheet. Cancel reverts both cells back to where they were. Always think before clicking OK — Goal Seek overwrites your input cell permanently when you accept the result. If you wanted to preserve the original 100, hit Cancel and write the answer down somewhere else first.
That is the complete workflow. Set cell, To value, By changing cell, OK. Once you have done it twice it stops feeling like a feature and starts feeling like a reflex.
The formula cell that holds your output. Goal Seek reads this but never writes to it. Selecting it before opening the dialog pre-fills the field.
The exact number you want the Set cell to equal. Type it as a plain number — no equals sign, no formula, no cell reference.
The single input cell Goal Seek is allowed to modify. It must contain a hard-coded value, not a formula, and your Set cell formula must depend on it.
You can afford $850 a month for a car loan. The dealer offers 6.5% APR over 60 months. What loan amount lands exactly on $850 a month? Build it:
Run Goal Seek on B4, target 850, changing B1. Excel returns about $43,442.38. That is the ceiling — borrow more and your payment exceeds budget. Less and you have wiggle room. The PMT function works with Goal Seek beautifully because both rely on the same underlying math.
A student has scores of 78, 82, 91, and 86 on four assignments. The final exam counts for 25% of the grade. The other four assignments split the remaining 75% equally. What does the final need to be for an overall 88?
Goal Seek on B6, target 88, changing B5. The answer comes back at 99.25. The student needs a 99.25 on the final to land exactly on an 88 overall, which tells them 88 is almost out of reach and a lower target such as 86 may be more realistic. That is the kind of answer mental math gives you a headache about; Goal Seek hands it over in under a second.
You run a small print shop. Each poster costs $4.20 to produce, you have $850 in monthly overhead, and you expect to sell 200 posters. What price gets you to zero profit (break-even)?
Set cell B5, to value 0, changing B1. Excel returns $8.45. Anything above that is profit. That single number drives every pricing decision after it.
You are saving for a down payment. You start with $15,000, plan to add $400 a month, and need $35,000 in 36 months. What annual return rate gets you there?
Run Goal Seek on B5, target 35000, changing B4. Excel returns roughly 0.0767, a 7.67% annual rate compounded monthly. Because that is a demanding return, you now know to raise the monthly deposit or extend the timeline instead of relying on a savings account.
PMT formula in B4, monthly payment as target, loan amount as input. Goal Seek finds the maximum loan that fits your monthly budget. Works with any APR and term length.
Weighted average formula in B6, target overall grade, final exam score as input. Useful for students and teachers calculating what score is needed on a remaining assessment.
Profit formula in B5, target of zero, price as input. The result is your floor price — anything below loses money, anything above is gross profit.
FV formula in B5, target final balance, rate as input. Tells you what return you need from a savings account or index fund to reach a savings goal in a given timeframe.
Goal Seek is fast and forgiving, but it is not magic. Four limitations decide whether it works for your problem:
One input cell only. Goal Seek solves for exactly one variable. If your model has two unknowns — say price and units sold — you cannot use it directly. For multi-variable problems, switch to Solver, which ships as an Excel add-in and handles many variable cells and constraints. Microsoft says the same: Goal Seek works with only one variable input value, and Solver is for more than one. Goal Seek is for the simple single-variable cases that come up daily; Solver is for the harder optimization problems that come up monthly.
Set cell needs a formula, and the changing cell should be a plain input. Microsoft requires the Set cell to contain a formula that references the changing cell. Point "By changing cell" at a hard-coded input such as a number, not at a formula like =B2*1.1, or Goal Seek will not be able to adjust it. Many users get tripped up here on the first try.
The relationship must be continuous and monotonic in practice. Goal Seek uses numerical iteration. It works well when the formula changes smoothly as the input changes. Step functions, IF statements with sharp boundaries, and lookups that snap between values often cause it to fail. The dialog will say Goal Seek may not have found a solution and your input cell will end up at some odd intermediate number.
Precision and iteration limits. Goal Seek iterates until it is close enough to the target or runs out of iterations. Excel's defaults are Maximum Iterations 100 and Maximum Change 0.001, and you can change both under File → Options → Formulas → Calculation options (Microsoft notes both commands use iteration in a controlled way). A smaller Maximum Change gives a more accurate result at the cost of more calculation time. For financial work the default is usually fine; for engineering and scientific work you sometimes need the tighter setting.
There is also a more subtle limitation: Goal Seek finds a solution, not necessarily the right one. If your formula has two valid inputs that produce the same output (think quadratic equations), Goal Seek lands on whichever one is closer to your starting guess. To find the other root, change your starting value to a number on the other side of zero and run Goal Seek again.
Excel has four what-if tools. Goal Seek works backward from one result, while the other three explore or optimize across inputs.
| Tool | Where to find it | Inputs it changes | Best use | Availability |
|---|---|---|---|---|
| Goal Seek | Data > What-If Analysis > Goal Seek | One changing cell | Find the single input that makes one formula hit a target value | Desktop Excel for Windows and Mac (Microsoft 365, 2024, 2021; also 2019 and 2016) |
| Solver | Data tab, Analyze group, after loading the Solver add-in | Many variable cells with constraints | Maximize, minimize or hit a target for one objective cell | Windows and Mac desktop; add-ins are not supported in Excel for the web |
| Data Table | Data > What-If Analysis > Data Table | One or two input cells (row and column input) | Show many outcomes of a formula across a range of input values | Excel 2016 to 2024 and Microsoft 365 |
| Scenario Manager | Data > What-If Analysis > Scenario Manager | Up to 32 changing values per scenario, any number of scenarios | Save and compare named sets of inputs | Same What-If Analysis menu as Goal Seek and Data Table |
Sources: Microsoft Support articles on Goal Seek, Solver and data tables.
You will see this message eventually. It does not mean Goal Seek is broken; it means the iteration ran out of road before reaching your target. Five causes account for almost every occurrence:
No solution exists. The target you typed may simply be impossible. If your formula computes maximum 100 and you ask for 150, no input value will get you there. Sanity-check the math before blaming Goal Seek. Plug in a wildly large and a wildly small value manually to see the formula's actual range.
Starting value is too far from the answer. Goal Seek follows the slope of your formula from the current input toward the target. If the slope flattens near your starting point, the algorithm wanders without making progress. Set the input cell to a more reasonable initial guess and try again. For loan amounts, start with a number in the right order of magnitude; for percentages, start with 0.05 or 0.10 rather than 1.
Circular references. If your formula references itself directly or indirectly, Goal Seek cannot iterate cleanly. Excel's status bar shows "Circular References" in the bottom left when this happens. Trace the chain with Formulas → Error Checking → Circular References and untangle the loop.
The formula has a flat spot. If your output stays constant across a wide range of inputs (because of a MIN, MAX, or IF clamp), Goal Seek thinks it has reached convergence prematurely. Restructure the formula or move the clamp logic out of the critical path.
Iteration limit too low. For unusually nonlinear formulas — option pricing, IRR-style cash flows, polynomial relationships — 100 iterations may not be enough. Open File → Options → Formulas and raise Maximum Iterations (for example to 1,000). Combined with a smaller Maximum Change, this helps with many stubborn cases.
When all else fails, do the iteration yourself. Type a value, see the result, adjust, repeat. Three or four rounds usually get you close. Then run Goal Seek from that better starting point and let it polish the answer. Manual narrowing plus automated finishing is the experienced analyst's habit.
The dialog box is simple, but a few habits separate occasional users from people who reach for it instinctively:
Save before you click OK. Goal Seek overwrites your input cell. If you accept a result and then realize you wanted to compare it against the original, the only way back is Ctrl+Z. Save the workbook first — or better, paste a copy of the input cell elsewhere — so you have a rollback.
Use named ranges for clarity. Instead of "Set cell B5, By changing cell B4," name them Profit and Units in the Name Box. The Goal Seek dialog accepts names and your workbook becomes self-documenting. Anyone opening it six months later sees "Set Profit to 2000 by changing Units" — a sentence instead of a coordinate puzzle.
Combine with data tables for sensitivity analysis. Goal Seek answers one question at a time. If you want to see how the answer changes across many scenarios (different rates, different prices, different terms), build a Data Table and reference the Goal Seek output. The two features sit next to each other in the What-If menu for a reason.
Automate repeated runs with VBA. If you need to run it across many rows, write a VBA loop using Range.GoalSeek. Reference the Excel VBA guide if you have never written a macro before. The syntax is one line: Range("B5").GoalSeek Goal:=2000, ChangingCell:=Range("B4").
Always double-check the result with a forward calculation. Goal Seek's answer can drift slightly from a perfect match because it stops within the Maximum Change tolerance. After the dialog closes, look at the output cell. If it shows 1999.9997 instead of 2000, decide whether that matters. For dollar amounts in budgeting, it usually does not. For engineering tolerances, it might.
One last habit: when you teach Goal Seek to a colleague, walk them through the loan example first. It is the most common real-world use case, the math is obvious, and the result is immediately useful. Within five minutes they will be running it on their own spreadsheets without prompting.
Hands-on use is what makes the steps stick. Open a blank workbook right now and rebuild the candle profit example from memory — no peeking at the steps above. If you can do it in under three minutes, you understand the feature. If you stumble, repeat it three times until the dialog stops feeling foreign.
Once you are comfortable, our practice tests cover Goal Seek alongside Solver, Scenario Manager, and the rest of Excel's data analysis tools. Working through scored questions reinforces the difference between when to use Goal Seek versus when to switch to Solver, which is the single most common mistake intermediate users make.
If you are preparing for an Excel certification — MOS Expert, the Excel Associate exam, or a job-screening assessment — Goal Seek is a standard what-if analysis topic worth practicing. Run the dialog several times yourself before the exam. For deeper preparation, our Excel cheat sheet collects the formulas, shortcuts, and quick references most often tested.
Try these questions from our free Excel practice tests. The correct answer and an explanation follow each question.
Which Excel feature automatically fills a column by detecting a pattern from examples you type, such as extracting first names?
Answer: B. Flash Fill
Flash Fill recognizes patterns and completes the column with Ctrl+E.
Which tab on the Excel ribbon contains the Sort and Filter commands?
Answer: A. Data
The Data tab contains Sort and Filter commands along with other data management tools like Data Validation, Text to Columns, and Remove Duplicates.
The numbers 75 and 75% are identical in Excel, correct or incorrect.
Answer: B. FALSE
The numbers 75 and 75% are not identical in Excel. While 75 represents the integer value seventy-five, 75% represents seventy-five hundredths, which is equivalent to the decimal value 0.75. Excel interprets percentages as fractions of 1, so entering 75% is the same as entering 0.75.
Which Excel chart type is best suited for showing the proportion of parts to a whole?
Answer: C. Pie chart
A pie chart displays each category as a slice of the whole circle, making part-to-whole relationships immediately visible.