Can You Use Goal Seek on Multiple Cells in Excel at Once?

No. In Microsoft Excel for Microsoft 365 on Windows, Goal Seek changes one input cell to make the value in one formula cell reach a target. You can run it again for another target, but if you need Excel to adjust several input cells together, use Solver instead.

What Goal Seek Can—and Cannot—Change

Goal Seek is a What-If Analysis tool for answering a focused question: “What value should this input have so that this formula returns the result I want?” You specify a formula cell, a target value, and one changing cell. Excel then tries different values in that input cell and recalculates the workbook until the formula reaches, or gets close to, the target.

The limit is one changing cell per Goal Seek run. That does not mean your workbook can contain only one input or one formula. The changing cell can affect many formulas throughout the workbook, and those formulas can all recalculate. However, the Goal Seek dialog accepts just one target formula cell and one input cell at a time. It does not jointly solve for several inputs or enforce several output targets in one run.

For example, if a worksheet calculates revenue, you can ask what number of units would produce a specified revenue while keeping the price fixed. You cannot use one Goal Seek run to change both the unit count and the price, nor ask it to make revenue and profit reach two separate targets simultaneously.

How Goal Seek Works

Goal Seek works backward from a result. You provide the desired value, and Excel repeatedly recalculates the formula while changing the selected input. In Excel for Microsoft 365 on Windows, open Data > What-If Analysis > Goal Seek. The dialog has three fields:

Set cell: The cell containing the formula whose result you want to control.
To value: The target result. Enter a number, not a cell reference or a formula.
By changing cell: The single input cell Excel may alter. It must be a value cell, not a formula cell.

After you choose OK, Excel searches for an input value that makes the formula result match the target. If it finds a solution, it displays the result and lets you keep it or restore the original value. Goal Seek is a numerical search, not a general-purpose proof that a solution exists. A result may be approximate, and the search can fail if the formula cannot reach the target from the starting conditions.

A Simple Example: Reaching a Revenue Target

Suppose a worksheet has the number of units in B2, the price per unit in B3, and total revenue in B4. With units in B2 and price in B3, enter this formula in B4:

=B2*B3

If B3 contains 15 and the target revenue is 1,200, open Goal Seek and enter B4 as the Set cell, 1200 as the To value, and B2 as the By changing cell. Excel returns 80 for B2, because 80 units multiplied by 15 per unit equals 1,200. The price stays fixed; Goal Seek changes only the unit count.

This example also shows why “multiple cells” can be ambiguous. If B2 is referenced by several formulas, changing B2 can update all of them. Goal Seek can still do that, because recalculation is not limited to one output cell. What it cannot do is use two different output cells as simultaneous goals or adjust two input cells as a pair.

Can You Run Goal Seek Repeatedly?

Yes. You can run it once for one target, keep the result, and then run it again for a different target. This is useful when the runs are independent—for instance, when you want to find a separate input value for each of several scenarios and record each result in its own copy of the model.

Repeated runs do not turn Goal Seek into a simultaneous multi-cell solver. If the second run changes an input that affects the first target, the first target may no longer be met. Likewise, if you use a different changing cell in a later run, Excel does not automatically preserve the earlier result as a constraint. You would need to check all relevant outputs after each change.

For a safe comparison, copy the starting inputs or duplicate the worksheet for each scenario. Record which input was changed and which target was set. This avoids confusing a sequence of separate answers with one set of values that satisfies every target at once.

When Solver Is the Better Tool

Use Solver when the problem requires Excel to change multiple decision cells together. Solver can vary a range of cells, optimize an objective formula, and apply constraints such as limits, equalities, or integer requirements. It is suited to questions such as how many units of several products to make when resources are limited, or how to choose several inputs to maximize an outcome.

In Excel for Microsoft 365 on Windows, Solver may need to be enabled first: choose File > Options > Add-ins. In the Manage box, select Excel Add-ins, choose Go, check Solver Add-in, and select OK. Then find Solver under Data > Solver.

Solver normally has one objective cell to maximize, minimize, or set to a particular value. It can also have multiple constraints. If you need several output cells to hit exact targets, those target requirements can be represented as constraints, provided the model has enough flexibility and the combination is feasible. If exact matching is not possible, a carefully designed objective that measures the overall deviation may be more appropriate. Solver settings and model design matter; it is not a guarantee that every requested target can be met.

On Excel for Mac, Solver is also an add-in, and its availability and setup are managed through Excel’s add-ins controls; after it is enabled, look for Solver on the Data tab. Ribbon layouts can differ slightly by platform and update. Excel for the web does not provide the same desktop Goal Seek workflow, so use the desktop Excel app for these What-If Analysis steps.

Goal Seek Compared with Other What-If Tools

Goal Seek, Solver, and data tables answer related but different questions. Picking the right tool prevents unnecessary trial and error:

Goal Seek: Find one input value that makes one formula reach one target. It is the simplest choice when all other inputs should stay fixed.
Solver: Adjust multiple cells to optimize one objective or meet constraints. Choose it for resource allocation, mixes, schedules, and other multi-variable models.
Data tables: Show how a formula changes across a range of one or two input values. A data table compares scenarios; it does not search for a solution or optimize the result.
Manual formulas or scenarios: For a small number of clearly defined cases, entering alternative inputs in separate rows or columns may be easier to review than using an iterative tool.

A common misconception is that a two-variable data table is equivalent to Goal Seek with two changing cells. It is not. The table calculates outputs for combinations of specified input values. It does not determine which combination satisfies a target unless you inspect the results and identify one yourself.

Common Setup Problems and Limits

If Goal Seek does not produce the expected result, first confirm the worksheet is structured correctly. The Set cell must contain a formula that depends, directly or indirectly, on the changing cell. The changing cell must be a single editable input, and the target must be a numeric value. If the selected formula does not depend on that input, changing it cannot move the result.

Other issues can arise from the shape of the formula. A target may be impossible—for example, a formula capped at 100 cannot reach 120. A formula may have several possible solutions, such as a squared input, or may change abruptly because of rounding, IF logic, lookup boundaries, or other discrete rules. Goal Seek may find one solution, converge to a nearby value, or fail to find a useful answer. Check the returned input and recalculate the formula rather than assuming that every result is exact.

Also check for hidden assumptions: units, signs, fixed values, and formulas copied to the correct cells. A target entered as 1.2 is not the same as 120 if the worksheet uses a different scale. If the model has circular references, check Excel’s iterative calculation settings and whether the workbook is designed to support them; Goal Seek is not a substitute for diagnosing a circular-reference problem.

A Practical Way to Choose

Before using a what-if tool, write down which values are allowed to change and what must be true at the end. That simple description usually identifies the right method:

If exactly one input may change and one formula must hit a target, use Goal Seek.
If several inputs may change but there is one main result to optimize, use Solver.
If several outputs must satisfy separate requirements, consider Solver constraints and confirm the requirements can coexist.
If you only want to compare known input combinations, use a data table or lay out scenarios explicitly.

Save a copy before experimenting with a complex workbook, especially if the changed value feeds many sheets or downstream calculations. Goal Seek changes the workbook’s input when you accept its result; the tool does not maintain a separate scenario history. Keeping a baseline makes it easier to compare the original model with the values found during analysis.

Frequently Asked Questions

Can Goal Seek change two cells at the same time?
No. Each Goal Seek run has one changing cell. Use Solver if Excel must adjust multiple inputs together.

Can Goal Seek target two formula cells at once?
No. A Goal Seek run sets one formula cell to one target value. Solver can handle multiple output requirements as constraints when the model and targets make that possible.

Can I run Goal Seek on several cells one after another?
You can run separate Goal Seek operations for different targets. But later runs can affect earlier results if they share inputs or formulas, so verify every required result after each run.

Does Goal Seek work if the target formula contains a formula error?
It needs a functioning formula to evaluate. Resolve errors such as #VALUE! or #DIV/0! in the calculation path first, then retry with valid inputs.

Is a two-variable data table the same as changing two cells with Goal Seek?
No. A two-variable data table calculates a formula for combinations of two input values you supply. It does not automatically search for the combination that reaches a target.

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.