Excel Goal Seek Explained With Example

Have you ever worked backwards from a result you wanted — trying to figure out what input value would produce a specific output in a formula?

Maybe you wanted to know what price you need to charge to hit a profit target. Or what interest rate would make your monthly loan payment fit your budget. Or how many units you need to sell to break even.

In most cases, you would try different input values manually — guess, check the result, adjust, check again until you get close enough. This is tedious, imprecise, and slow.

Excel Goal Seek solves this instantly. You tell Excel what output you want, which cell contains that output formula, and which input cell to change and Excel automatically calculates the exact input value that produces your target result.

In this guide, we will break down Goal Seek completely — what it is, how to use it step by step, real-world examples, and when to use it versus Excel Solver.

What Is Goal Seek in Excel?

Goal Seek is a what-if analysis tool built into Excel that works backwards from a desired result to find the input value that produces it.

It answers the question: “If I want this formula to equal this value, what does this input cell need to be?”

Simple Analogy

Imagine you are baking a cake and the recipe says 200g of flour produces 8 servings. You want 12 servings. How much flour do you need?

You could calculate it mathematically. Or you could tell Goal Seek: “I want the servings cell to equal 12 — what should the flour cell be?” and Goal Seek instantly tells you 300g.

Goal Seek does exactly this for any Excel formula — regardless of how complex it is.

The Three Components of Goal Seek

Every Goal Seek operation requires three things:

Set Cell — The cell containing the formula you want to reach a specific value. This cell must contain a formula that depends on the Changing Cell.

To Value — The target value you want the Set Cell to reach.

By Changing Cell — The single input cell that Goal Seek will adjust to make the formula reach your target value.

Where to Find Goal Seek in Excel

Goal Seek is located in the What-If Analysis menu:

Data tab → Forecast group → What-If Analysis → Goal Seek

In some Excel versions:

Data tab → Data Tools group → What-If Analysis → Goal Seek

Step-by-Step: Your First Goal Seek

Example 1: Hitting a Profit Target

Setup:

	A	B
1	Revenue	$100,000
2	Costs	$75,000
3	Profit	=B1-B2

Current profit is $25,000. You want to know what revenue you need to achieve a profit of $40,000 — keeping costs fixed.

Step 1: Click on the formula cell

Click on cell B3 — the cell containing your profit formula =B1-B2. This is important — Goal Seek works best when you start by selecting the formula cell.

Step 2: Open Goal Seek

Data tab → What-If Analysis → Goal Seek

The Goal Seek dialog opens with three fields.

Step 3: Configure the three fields

• Set cell: B3 (your formula cell — already filled if you selected it first)
• To value: 40000 (your target profit)
• By changing cell: B1 (the revenue cell you want Goal Seek to adjust)

Step 4: Click OK

Excel runs its iterative calculation and returns a result:

Goal Seek Status: Goal Seeking with cell B3 found a solution.
Target value: 40000
Current value: 40000

Cell B1 now shows $115,000 — the exact revenue needed to achieve $40,000 profit with $75,000 costs.

Step 5: Accept or cancel the result

• Click OK to keep the solution — B1 permanently changes to $115,000
• Click Cancel to restore the original values

Best practice: Before running Goal Seek on important models, save a copy or note the original values. Clicking OK permanently changes your worksheet.

How Goal Seek Works Internally

Goal Seek uses an iterative numerical method — it tries different values for the changing cell, checks how close the formula result is to your target, and adjusts in the direction that closes the gap.

It repeats this process up to 100 times (by default) with adjustments becoming smaller and smaller until it either:

• Finds a value where the formula result equals the target within an acceptable tolerance
• Reaches the maximum number of iterations without converging

This iterative approach means Goal Seek works for any formula — not just simple linear equations. It handles compound interest, logarithms, and complex nested formulas.

Changing Iteration Settings

For complex problems where Goal Seek does not converge on the right answer, you can adjust the iteration limits:

File → Options → Formulas

• Maximum Iterations — Default 100. Increase for complex problems.
• Maximum Change — Default 0.001. Decrease for more precise results.

Real-World Examples

Example 2: Loan Payment Calculator

Goal: Find the interest rate that produces a specific monthly payment.

Setup:

	A	B
1	Loan Amount	$250,000
2	Annual Interest Rate	5%
3	Loan Term (months)	360
4	Monthly Payment	=PMT(B2/12, B3, -B1)

Current monthly payment with 5% interest is approximately $1,342.05.

You can afford $1,200 per month. What interest rate makes that work?

Goal Seek settings:

• Set cell: B4
• To value: 1200
• By changing cell: B2

Result: Goal Seek finds approximately 3.83% annual interest rate produces a $1,200 monthly payment on a $250,000 30-year loan.

Example 3: Break-Even Analysis

Goal: Find the number of units to sell to break even.

Setup:

	A	B
1	Fixed Costs	$50,000
2	Variable Cost per Unit	$15
3	Selling Price per Unit	$35
4	Units Sold	1000
5	Total Revenue	=B4*B3
6	Total Costs	=B1+(B4*B2)
7	Profit/Loss	=B5-B6

Current profit with 1,000 units is -$30,000 (a loss).

Goal Seek settings:

• Set cell: B7 (Profit/Loss)
• To value: 0 (break even)
• By changing cell: B4 (Units Sold)

Result: Goal Seek finds you need to sell 2,500 units to break even.

Verification: Revenue = 2,500 × $35 = $87,500. Costs = $50,000 + (2,500 × $15) = $87,500. Profit = $0. ✅

Example 4: Investment Return Target

Goal: Find the annual growth rate needed to reach a savings target.

Setup:

	A	B
1	Initial Investment	$10,000
2	Annual Growth Rate	6%
3	Years	10
4	Future Value	=B1*(1+B2)^B3

Current future value at 6% over 10 years is approximately $17,908.

You want to reach $25,000. What annual growth rate do you need?

Goal Seek settings:

• Set cell: B4
• To value: 25000
• By changing cell: B2

Result: Goal Seek finds you need approximately 9.60% annual growth rate to turn $10,000 into $25,000 in 10 years.

Example 5: Grade Calculator

Goal: Find the score needed on the final exam to achieve a target course grade.

Setup:

	A	B
1	Assignment 1 (20%)	78
2	Assignment 2 (20%)	85
3	Midterm (30%)	72
4	Final Exam (30%)	80
5	Course Grade	=0.2B1+0.2B2+0.3B3+0.3B4

Current weighted average: 78.5. You need 85 to get an A.

Goal Seek settings:

• Set cell: B5
• To value: 85
• By changing cell: B4

Result: Goal Seek finds you need 100.33 on the final exam to reach an 85 course grade. Since this exceeds 100, you know an A is mathematically impossible given your current scores.

This is one of Goal Seek’s most valuable contributions — quickly proving whether a target is achievable, not just what input would achieve it.

Example 6: Pricing for Margin Target

Goal: Find the selling price that achieves a target gross margin percentage.

Setup:

	A	B
1	Cost of Goods	$45.00
2	Selling Price	$75.00
3	Gross Margin %	=(B2-B1)/B2

Current gross margin: 40%. You want to achieve 55% gross margin.

Goal Seek settings:

• Set cell: B3
• To value: 0.55 (55% as a decimal)
• By changing cell: B2

Result: Goal Seek finds a selling price of $100.00 achieves a 55% gross margin on a $45.00 cost item.

Verification: ($100 – $45) / $100 = 55%.

Running Goal Seek Multiple Times With Different Scenarios

Goal Seek solves one scenario at a time but you can run it multiple times with different target values to build a scenario comparison table manually.

Example — Loan scenarios:

Target Payment	Interest Rate Found
$1,000/month	Goal Seek → 2.21%
$1,200/month	Goal Seek → 3.83%
$1,500/month	Goal Seek → 6.21%
$1,800/month	Goal Seek → 8.52%

Run Goal Seek once for each target payment and record the result. This builds a sensitivity table showing the range of acceptable interest rates.

For generating multiple scenarios automatically, use Data Tables (also under What-If Analysis) or Excel Solver for multi-variable problems.

Goal Seek vs Solver — When to Use Each

Both Goal Seek and Solver are what-if analysis tools but they serve different levels of complexity.

Goal Seek

• Adjusts one changing cell only
• Seeks one specific target value
• No constraints — the changing cell can take any value
• No optimization — finds a solution, not the best solution
• Simple to use — three fields, done
• Best for: single-variable back-calculation problems

Solver

• Adjusts multiple changing cells simultaneously
• Can minimize or maximize the target, or hit a specific value
• Supports constraints — the changing cells must stay within defined bounds
• Performs optimization — finds the best solution given constraints
• More complex to configure — requires understanding of the optimization problem
• Best for: multi-variable optimization, resource allocation, scheduling

Use Goal Seek when: You need to find what one input value must be to achieve a specific target output.

Use Solver when: You need to optimize a result by adjusting multiple variables subject to constraints.

Feature	Goal Seek	Solver
Changing cells	1	Many
Target type	Specific value	Specific value, max, or min
Constraints	None	Yes
Optimization	No	Yes
Complexity	Very simple	Moderate
Best for	Back-calculation	Optimization problems

Goal Seek With Lookup Formulas

Goal Seek works with any formula including those with nested IF, VLOOKUP, or complex logic as long as the changing cell has a continuous mathematical effect on the formula result.

Example — Tax Bracket Calculation

If your formula uses an IF statement that changes based on income thresholds, Goal Seek can find the income that produces a target tax amount:

B6: =IF(B1<50000, B1*0.20, IF(B1<100000, B1*0.28, B1*0.37))

Goal Seek: Set B6 to 15000, changing B1 → finds the income that produces $15,000 in tax.

Note: Formulas with discontinuities (large jumps from one IF branch to another) can cause Goal Seek to find different solutions depending on the starting value. Always verify Goal Seek results when complex conditional logic is involved.

Common Limitations of Goal Seek

Only One Variable

Goal Seek changes exactly one cell. If your problem requires adjusting two or more inputs simultaneously, you need Solver.

Requires a Continuous Relationship

Goal Seek uses numerical iteration — it needs the formula result to change smoothly as the input changes. Formulas that produce identical results across a range of inputs (like step functions or text lookups) may confuse Goal Seek.

May Find Local Solutions

For highly nonlinear formulas, Goal Seek may converge on a local solution — a value that satisfies the target but is not the only solution or not the most useful one. For example, a quadratic equation can have two solutions, but Goal Seek will only find one.

No Constraints

Goal Seek will happily find negative prices, fractional people counts, or other mathematically valid but practically impossible values. Always check that the Goal Seek result is realistic for your context. Use Solver with constraints when the changing cell must stay within specific bounds.

Circular References

Goal Seek cannot work with circular references — formulas where a cell depends on itself. Ensure your model has clear, non-circular dependencies before running Goal Seek.

Common Mistakes to Avoid

• Selecting the wrong Set Cell — The Set Cell must contain a formula that depends on the Changing Cell — not a hardcoded value. If the Set Cell does not change when the Changing Cell changes, Goal Seek cannot find a solution
• Not saving before running Goal Seek — Clicking OK permanently modifies your worksheet. If you need the original values for comparison, save a copy or note the original values before running
• Entering a percentage as a whole number in “To Value” — If your formula returns a percentage as a decimal (0.55 for 55%), enter 0.55 in the To Value field — not 55. Entering 55 tells Goal Seek to find when the formula equals 5,500%
• Expecting Goal Seek to work with text formulas — Goal Seek only works with numerical formulas. Formulas that return text cannot be used as the Set Cell
• Not verifying the result — Always manually check that the Goal Seek result is correct by confirming the formula in the Set Cell shows your target value and that the Changing Cell value makes practical sense
• Using Goal Seek when Solver is needed — If your problem requires multiple changing cells or constraints, Goal Seek will produce incomplete results. Recognize when Solver is the right tool

Goal Seek Cheat Sheet

Scenario	Set Cell	To Value	By Changing Cell
Revenue needed for profit target	Profit formula	Target profit	Revenue cell
Interest rate for payment target	PMT formula	Target payment	Interest rate cell
Units to break even	Profit/Loss formula	0	Units sold cell
Growth rate for investment goal	FV formula	Target amount	Growth rate cell
Price for margin target	Margin % formula	Target % (decimal)	Price cell
Score needed for grade target	Weighted avg formula	Target grade	Final exam score cell

Goal Seek is one of Excel’s most underappreciated features — it solves in seconds a class of problems that would otherwise require trial and error or complex algebra.

Here is the simplest summary of everything we covered:

• Goal Seek works backwards from a target value to find the required input
• It changes exactly one cell to make a formula reach your specified value
• Access it through Data → What-If Analysis → Goal Seek
• Configure three things: Set Cell (formula), To Value (target), By Changing Cell (input)
• Click OK to accept the result — the worksheet changes permanently
• Use Goal Seek for single-variable back-calculation
• Use Solver when you need multiple changing cells, optimization, or constraints

Start with a simple example — find what revenue produces a target profit. Once that feels comfortable, apply Goal Seek to loan calculations, break-even analysis, and investment planning. It will save you significant time on any problem where you know the answer you want and need to find the input that produces it.

FAQs