Excel Goal Seek vs Solver: Which Tool Should You Use?

Use Goal Seek when you know the result you want from one formula and need Excel to find the single input that produces it. Use Solver when you need to maximize, minimize, or hit a target while changing several inputs, possibly subject to limits such as capacity or budget.

Both are what-if analysis tools in Microsoft Excel for Microsoft 365, but they answer different questions. Goal Seek works backward from a target in a formula; Solver searches a more flexible model for a useful solution. Choosing the right one depends mainly on how many input cells can change and whether your problem has constraints.

At a glance: the main difference

Goal Seek: changes one input cell so a formula cell reaches a specified value. You supply the target; it does not decide whether the result is best.
Solver: changes one or more input cells to maximize or minimize an objective, or make it equal a target, while following constraints you define.
Both: require a working worksheet model. They change input values in the workbook; neither can answer a question that is not represented by formulas and cell relationships.

A simple distinction is target-finding versus optimization. If a sales forecast needs to show how many units produce $12,000 in profit, Goal Seek may be enough. If the question is which combination of products earns the most while staying within labor and demand limits, Solver is the better fit.

How Goal Seek works

Goal Seek repeatedly adjusts one cell and recalculates a formula until the formula is close to the value you specified. In Excel for Windows, open Data > What-If Analysis > Goal Seek. The dialog asks for three entries: the formula cell to set, the target value, and the one input cell Excel may change.

The formula cell must contain a formula that depends, directly or indirectly, on the changing cell. For example, Excel cannot make a typed number in a cell reach a target by changing an unrelated input. Goal Seek also does not choose among multiple inputs, impose a maximum or minimum on the changing cell, or search for the largest possible result. It is solving one equation numerically, not comparing business plans.

Because the process is iterative, the answer may be approximate, and a model with discontinuities, rounding, or multiple possible roots can make the result sensitive to the starting value. Review the returned value and recalculate the worksheet rather than assuming that a displayed answer is exact.

How Solver works

Solver treats a worksheet as an optimization model. You identify an objective cell, choose whether to maximize it, minimize it, or set it to a particular value, then identify the cells Solver may change. You can add constraints, such as a total that must stay below a limit, a decision variable that must be an integer, or a variable that cannot be negative.

On Windows, Solver is an Excel add-in. If it is not on the Data tab, use File > Options > Add-ins. At the bottom, choose Excel Add-ins in the Manage box, select Go, check Solver Add-in, and select OK. Solver then appears on the Data tab, usually in the Analysis group. The standard Solver add-in supports up to 200 changing variable cells.

Solver offers different methods for different models. Simplex LP is intended for linear models; GRG Nonlinear is for smooth nonlinear models; and Evolutionary can handle certain less-smooth or discontinuous models. The method matters: nonlinear searches can find a local solution rather than prove that no better solution exists anywhere, while a correctly specified linear model is suited to linear optimization.

A worked example: when Goal Seek is enough

Imagine a simplified product forecast with a selling price of $40 per unit, a variable cost of $24 per unit, and fixed costs of $8,000. Put the selling price in B2, variable cost in B3, units sold in B4, and fixed costs in B5. With those values in the indicated cells, enter this formula in B6 to calculate profit:

=(B2-B3)*B4-B5

At 1,000 units, the result is $8,000: ($40 − $24) × 1,000 − $8,000. If the target profit is $12,000, open Goal Seek and set cell B6 to 12000 by changing B4. The result is 1,250 units, because ($40 − $24) × 1,250 − $8,000 = $12,000. This example is illustrative arithmetic, not financial advice; actual costs, demand, and business assumptions need to be checked.

Goal Seek is appropriate because there is one target formula and one adjustable input. If units must be whole numbers, 1,250 already satisfies that requirement; if the answer were fractional, Goal Seek would not enforce whole units for you. You would need to interpret or round the answer and check the resulting profit, or build a constrained model in Solver.

A worked example: when Solver is better

Suppose a small workshop can make three products. Put the planned quantities in B2:B4, contribution per unit in C2:C4, and labor hours per unit in D2:D4. For this illustration, contributions are $30, $25, and $18; labor requirements are 2, 1, and 0.5 hours; maximum demand is 50, 100, and 200 units; and 180 labor hours are available.

With quantities in B2:B4 and labor hours per unit in D2:D4, enter this formula in B5 to calculate labor used:

=SUMPRODUCT(B2:B4,D2:D4)

With quantities in B2:B4 and contributions in C2:C4, enter this formula in B6 to calculate total contribution:

=SUMPRODUCT(B2:B4,C2:C4)

In Solver, set B6 as the objective and choose Max. Set B2:B4 as the changing variable cells. Add constraints B5 <= 180, B2 <= 50, B3 <= 100, and B4 <= 200; require B2:B4 to be nonnegative integers. In this simplified model, an optimal plan is 0 units of product one, 80 of product two, and 200 of product three. It uses 180 hours and returns $5,600 in contribution: 80 × $25 + 200 × $18. Solver is useful here because it must compare combinations and observe several limits at once.

This is a simplified planning example, not a claim that contribution alone captures every real production decision. A real model might need material limits, setup costs, minimum production runs, or demand uncertainty. Those conditions must be represented accurately for Solver’s answer to be meaningful.

Goal Seek vs Solver: a practical comparison

Question	Goal Seek	Solver
How many changing cells?	One	One or more
What is the aim?	Make a formula equal one chosen value	Maximize, minimize, or reach a target
Can you add constraints?	No	Yes
Typical example	Find units needed for a target profit	Choose a product mix under capacity limits
Setup	Built into What-If Analysis	May need to enable the Solver add-in

These tools are related, but Solver is not simply a more precise version of Goal Seek. Goal Seek is faster to set up for a single target and one input. Solver gives you a model with an objective and restrictions, but the extra flexibility also makes correct model design more important.

How to choose the right tool

Start by writing the question in plain language, then identify the formula that measures the outcome and the cells that could change. Choose Goal Seek if all of these are true:

You have one formula result with a specific target value.
Only one input cell needs to change.
You do not need Excel to enforce limits or compare alternative objectives.

Choose Solver if you need to change multiple decisions, optimize an outcome, or enforce constraints. It is commonly useful for product mix, staffing, delivery allocation, and resource planning. If the model includes yes-or-no choices, whole-number quantities, or maximums and minimums, Solver can represent those conditions with constraints where supported.

If your problem appears to need Solver but the model is large or nonlinear, first make a small, transparent version and confirm that its formulas and constraints behave as expected. Solver’s answer is only as useful as the objective, assumptions, and restrictions you entered.

Availability and platform differences

The steps above describe Excel for Microsoft 365 on Windows. In Excel for Mac, Goal Seek is also available from the Data tab’s What-If Analysis menu. To enable Solver on Mac, open Tools > Excel Add-ins, select Solver Add-in, and then use Solver from the Data tab. Menu wording and placement can vary slightly by release.

Solver is a desktop Excel add-in and is not available to run in Excel for the web in the same way as the Windows or Mac add-in. If a workbook is opened in a browser, use desktop Excel for Solver work. Before sharing a workbook, remember that the worksheet’s formulas and saved values can be viewed even if another person does not have Solver enabled.

Common problems and how to avoid them

Goal Seek cannot find the target: check that the set cell contains a formula and that changing the selected input actually affects it. Also check whether the target is mathematically possible within realistic input values.
The result is surprising: inspect the formula references, units, and assumptions. A target can be reached for the wrong reason if the model is incomplete or a cell reference is incorrect.
Solver reports no feasible solution: your constraints may conflict. For example, required production could exceed available capacity. Temporarily review constraints one at a time and confirm that the model permits at least one valid combination.
Solver’s result is not the best-looking answer: confirm the objective direction, changing cells, and constraints. For nonlinear models, try a reasonable starting point and method, then compare plausible solutions.
Values change after accepting a solution: Solver and Goal Seek modify worksheet inputs. Save a copy or note the original values before running them if you need to preserve the starting scenario.

A common misconception is that Solver automatically knows what is realistic. It does not. If you forget a demand limit or enter the wrong objective cell, Solver can return a mathematically valid answer that is useless for the real decision. Check the result against the original question.

Alternatives and useful next steps

For a small number of scenarios, a data table or a set of clearly labeled assumptions may be easier to audit than an optimization model. Excel’s What-If Analysis tools also include Scenario Manager and Data Tables, which help compare inputs and outputs rather than optimize a set of decisions. For a complex model with many variables, nonlinear behavior, or requirements beyond the standard add-in’s limits, specialized optimization software may be more appropriate.

Regardless of the tool, keep decision inputs separate from formulas, label units, and document constraints in the worksheet. That makes it easier to spot an incorrect assumption, reproduce a result, and explain why the model returned a particular answer.

Frequently Asked Questions

Is Solver better than Goal Seek?
Not for every task. Goal Seek is simpler when one input must produce one target result. Solver is more capable when several inputs, an optimization objective, or constraints are involved.

Can Goal Seek change more than one cell?
No. Goal Seek changes one input cell per run. To vary several decision cells together or apply restrictions, use Solver.

Does Solver always find the global best answer?
No. For nonlinear models, the result may be a local solution and can depend on starting values and method. A model’s structure and Solver method determine how confidently a result can be interpreted.

Why is Solver missing from Excel?
On Windows, enable the Solver Add-in through File > Options > Add-ins, then choose Excel Add-ins in the Manage box and select Go. On Mac, check Tools > Excel Add-ins. Solver is not run as the desktop add-in in Excel for the web.

Can Goal Seek enforce a minimum or maximum?
No. It finds an input for a target but does not enforce bounds. If the answer must stay within limits, use Solver and add the relevant constraints.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.