How to Use Goal Seek in Excel: Step-by-Step Tutorial, Examples, and Limits

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.

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.

What Is Goal Seek and When Do You Use It?

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:

• A loan calculator already shows your monthly payment, but you want to know the maximum loan amount your budget allows.
• A pricing model returns gross margin, but you want to find the unit price that hits a 35% margin.
• A student's grade workbook computes a weighted average, but you want to know what final exam score guarantees an A.
• A profit-and-loss sheet shows net income, but you want the sales volume that reaches break-even.

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.

Where to Find Goal Seek in Excel

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:

• Set cell — the cell containing your formula (the output you care about).
• To value — the number you want that formula to equal.
• By changing cell — the single input cell Excel is allowed to modify.

Three fields. That is the whole interface. The simplicity is the point.

Step-by-Step: Using Goal Seek for the First Time

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:

• Cell B1: Price per unit → 24
• Cell B2: Variable cost per unit → 9
• Cell B3: Fixed costs → 1200
• Cell B4: Units sold → 100 (starting guess)
• Cell B5: Profit → =B4*(B1-B2)-B3

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:

• Set cell: B5 (already filled)
• To value: Type 2000
• By changing cell: Click B4 (units sold)

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.

Four Real-World Goal Seek Examples

Example 1: Find the Loan Amount Your Budget Allows

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:

• B1: Loan amount → 25000 (starting guess)
• B2: Annual rate → 0.065
• B3: Term (months) → 60
• B4: Monthly payment → =PMT(B2/12, B3, -B1)

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.

Example 2: Hit a Specific Grade Average

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?

• B1: Assignment 1 → 78
• B2: Assignment 2 → 82
• B3: Assignment 3 → 91
• B4: Assignment 4 → 86
• B5: Final exam → 85 (starting guess)
• B6: Final grade → =AVERAGE(B1:B4)*0.75 + B5*0.25

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.

Example 3: Find a Break-Even Price

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)?

• B1: Price → 10 (guess)
• B2: Variable cost → 4.20
• B3: Fixed costs → 850
• B4: Units → 200
• B5: Profit → =B4*(B1-B2)-B3

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.

Example 4: Solve for an Interest Rate

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?

• B1: Starting balance → 15000
• B2: Monthly deposit → 400
• B3: Months → 36
• B4: Annual rate → 0.04 (guess)
• B5: Final balance → =FV(B4/12, B3, -B2, -B1)

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.

The Limits Every User Should Know

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.

Goal Seek vs Solver vs Data Table vs Scenario Manager

Excel has four what-if tools. Goal Seek works backward from one result, while the other three explore or optimize across inputs.

Sources: Microsoft Support articles on Goal Seek, Solver and data tables.

"Goal Seek Did Not Find a Solution" — Why and How to Fix

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.

Tips From Daily Goal Seek Users

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.

Practice What You Learned

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.

Sample Excel Practice Questions

Try these questions from our free Excel practice tests. The correct answer and an explanation follow each question.

1. Which Excel feature automatically fills a column by detecting a pattern from examples you type, such as extracting first names?

   • A. AutoSum
   • B. Flash Fill
   • C. Goal Seek
   • D. Data Validation

   Answer: B. Flash Fill

   Flash Fill recognizes patterns and completes the column with Ctrl+E.

2. Which tab on the Excel ribbon contains the Sort and Filter commands?

   • A. Data
   • B. Home
   • C. View
   • D. Insert

   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.

3. The numbers 75 and 75% are identical in Excel, correct or incorrect.

   • A. TRUE
   • B. FALSE

   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.

4. Which Excel chart type is best suited for showing the proportion of parts to a whole?

   • A. Line chart
   • B. Bar chart
   • C. Pie chart
   • D. Scatter chart

   Answer: C. Pie chart

   A pie chart displays each category as a slice of the whole circle, making part-to-whole relationships immediately visible.

Take the full Excel practice test