Goal Seek vs Solver in Excel: Which One Do You Need?

You need Goal Seek when one input cell has to change so that one formula hits one exact value, with no constraints. You need Solver when several input cells can change (up to 200), the answer must respect constraints, or you want to maximize or minimize a result instead of hitting a fixed number. Goal Seek is built into Excel; Solver is a free add-in you enable once.

What is the difference between Goal Seek and Solver?

Goal Seek is a one-variable root-finder: one changing cell, one target cell, one exact target value, no constraints. Solver is an optimization engine: many changing cells, an objective you can set to Max, Min, or a value, plus a list of constraints the answer must respect. Everything else — where they live in the ribbon, setup effort, speed — follows from that difference.

	Goal Seek	Solver
Changing cells	Exactly 1	Up to 200
Target	One exact value	Max, Min, or exact value
Constraints	None	Yes (<=, >=, =, integer, binary)
Availability	Built in	Add-in (free, must be enabled)
Location	Data → What-If Analysis	Data → Analyze → Solver
Setup time	Seconds	Minutes
Typical use	Break-even, required rate	Product mix, scheduling, budgets

When should you use Goal Seek instead of Solver?

Use Goal Seek when your question has the shape "set cell X so that formula Y equals Z": one unknown, one equation, one target number, and no limits on the answer. Break-even units, the interest rate that makes a loan payment affordable, and the exam score needed for a target average all fit that shape.

Worked example: B1 holds units sold, and B5 holds the profit formula =B1*49-12000-B1*18 ($49 price, $18 unit cost, $12,000 fixed costs). To find break-even:

Data → What-If Analysis → Goal Seek
  Set cell:        B5
  To value:        0
  By changing cell: B1

Result: B1 = 387.1 units to break even

Goal Seek overwrites the changing cell with its answer, so click Cancel if you only wanted to peek. Full walkthrough with more scenarios in our Goal Seek guide.

When do you need Solver instead of Goal Seek?

You need Solver as soon as the problem has more than one unknown, any constraint, or a goal to maximize or minimize rather than hit a fixed number. Goal Seek cannot express any of those; Solver handles all three in one dialog.

Worked example, a product-mix problem: you make desks (profit $320, 4 build-hours each) and chairs (profit $140, 1.5 build-hours each) with 240 build-hours available and at most 70 total units. Maximize profit:

B1 = desks made, B2 = chairs made
B4 = 320*B1 + 140*B2            ' objective: total profit
B5 = 4*B1 + 1.5*B2              ' hours used

Data → Solver
  Set Objective:      B4  →  Max
  By Changing Cells:  B1:B2
  Constraints:        B5 <= 240
                      B1 + B2 <= 70
                      B1, B2 = integer, >= 0
  Solving Method:     Simplex LP

Result: 54 desks + 16 chairs = $19,520

That mix uses all 240 hours and all 70 units. Desks earn more per unit, chairs earn more per build-hour, and the best answer balances the two under both limits. No sequence of Goal Seek runs could find it, because the two variables trade off against each other under shared constraints. Solver setup details, solving-method choice, and troubleshooting live in our Excel Solver guide.

How do I enable the Solver add-in?

Solver ships with Excel but is switched off by default. Enable it once and it stays on:

File → Options → Add-ins
  Manage: Excel Add-ins → Go...
  ☑ Solver Add-in → OK

Solver then appears at Data → Analyze → Solver

On Mac: Tools → Excel Add-ins → tick Solver Add-in. If the checkbox is missing entirely, your Excel installation skipped it — rerun Office setup or, in Excel for the web, note that Solver is only available via the Office add-in store version with reduced limits.

Can I use them together?

Yes, and it is a natural workflow: use Goal Seek for quick single-variable sanity checks while building the model ("what discount rate zeroes the NPV?"), then graduate to Solver when the real decision involves several levers and limits. Both tools sit alongside Scenario Manager and data tables under the same umbrella — see What-If Analysis in Excel for how the four tools divide the territory. One caution that applies to both: they find a solution from your starting values. For Solver's nonlinear (GRG) method especially, rerun from different starting numbers to make sure you did not land on a merely local optimum.