How to Use Goal Seek in Excel

Introduction

You have a profit model that depends on ticket price, attendees, and costs. Profit comes out to $1,000 but you need $3,000. You could rearrange the formulas and solve for the right ticket price by hand, but Goal Seek does it for you. Point it at the result cell, tell it the target, and pick which input to change. It finds the answer in seconds.

The Spreadsheet

Here's a workshop planning model with four inputs and four formulas:

	A	B
2	Fixed Costs	4000
3	Cost per Attendee	20
4	Attendees	50
5	Ticket Price	120
6	Revenue	=B4*B5
7	Variable Costs	=B4*B3
8	Total Costs	=B2+B7
9	Profit	=B6-B8

Revenue (B6) is Attendees times Ticket Price: 50 × $120 = $6,000. The variable costs in B7 run $20 per person, or $1,000 for 50 attendees. Total Costs (B8) combines fixed and variable: $4,000 + $1,000 = $5,000. Subtract that from revenue and Profit (B9) lands at $1,000.

The model works, but $1,000 in profit isn't enough. You need $3,000. What should you charge?

Running Goal Seek

1. Go to Data > What-If Analysis > Goal Seek.
2. Set cell: B9 (Profit).
3. To value: 3000.
4. By changing cell: B5 (Ticket Price).
5. Click OK.

Goal Seek adjusts B5 until B9 hits $3,000. The answer: $160.

Check the math: Revenue = 50 × $160 = $8,000. Variable Costs = 50 × $20 = $1,000. Total Costs = $4,000 + $1,000 = $5,000. Profit = $8,000 - $5,000 = $3,000.

Key takeaway: Goal Seek needs three things: the cell containing the result, the value you want it to reach, and the single input cell to adjust. It works backward through the entire formula chain to find the right input.

Adjusting a Different Variable

Same target, different lever. Keep the ticket price at $120 and find how many attendees produce $3,000 in profit.

Press Ctrl + Z to undo the previous run and restore B5 to $120. Goal Seek overwrites the changing cell, so always reset before running a new scenario.

1. Go to Data > What-If Analysis > Goal Seek.
2. Set cell: B9.
3. To value: 3000.
4. By changing cell: B4 (Attendees).
5. Click OK.

Goal Seek returns 70.

Check: Revenue = 70 × $120 = $8,400. Variable Costs = 70 × $20 = $1,400. Total Costs = $4,000 + $1,400 = $5,400. Profit = $8,400 - $5,400 = $3,000.

Goal Seek doesn't care which input you adjust. It only needs the result cell to depend on the changing cell through formulas. Here, Profit depends on Attendees through both the Revenue and Variable Costs lines.

Finding the Break-Even Point

Goal Seek handles break-even questions directly. To find the ticket price where profit equals zero, reset the spreadsheet and run Goal Seek with a target of 0:

1. Set cell: B9.
2. To value: 0.
3. By changing cell: B5 (Ticket Price).

Goal Seek returns $100.

Check: Revenue = 50 × $100 = $5,000. Variable Costs = $1,000. Total Costs = $4,000 + $1,000 = $5,000. Profit = $5,000 - $5,000 = $0.

At $100 per ticket, revenue exactly covers all costs. Anything above $100 generates profit. Anything below means a loss. This is the break-even price for 50 attendees with this cost structure.

When Goal Seek Falls Short

Goal Seek handles single-variable problems well, but it has limits:

• One variable at a time. You can only change one cell per run. To optimize both ticket price and attendees simultaneously, you need Solver (Data > Solver), which handles multiple variables and constraints.
• No constraints. Goal Seek returns whatever number makes the formula work, including negatives and fractions. If it returns 62.5 attendees, you need to round up to 63 yourself.
• Overwrites the cell. The changing cell holds the new value permanently after Goal Seek finishes. Note the original value beforehand, or press Ctrl + Z immediately to revert.
• May not converge. Goal Seek uses iteration to approach the target. For most spreadsheets it finishes instantly, but highly nonlinear formulas can cause it to stop short or fail. If it reports that it couldn't find a solution, check whether one actually exists for that target value.

Conclusion

Goal Seek finds the input that produces a specific result, working backward through your formulas so you don't have to rearrange anything. It handles pricing targets, break-even points, and any scenario where you know the answer you want but not the input to get there.

For building payment models that Goal Seek can reverse-engineer, see our guide on PMT. For a formula-based approach to calculating break-even points, check out our guide on break-even analysis.