Excel’s Goal Seek can solve for one changing cell to make one formula reach one target per run; it cannot set several targets at once. For multiple outputs or changing cells, use Solver to build a model, or run separate Goal Seek operations when the goals are genuinely independent.
What Goal Seek does—and what “multiple” can mean
Goal Seek is a built-in what-if analysis tool in the desktop versions of Excel. It works backward from a desired result: you identify a formula cell, specify the value you want that formula to return, and choose one input cell Excel may change. Excel then adjusts that input until the formula reaches, or gets close to, the target.
The word “multiple” can refer to different tasks, and the distinction matters:
- Several targets, one input: You want one input value to make several different result cells hit their targets at the same time. A single Goal Seek run cannot do this.
- One target, several inputs: You want Excel to adjust multiple input cells to achieve one result. Goal Seek cannot change multiple cells, but Solver can.
- Several independent scenarios: You want to find an input for each of several separate targets. Run Goal Seek once per scenario, or automate the repeated runs.
These are not interchangeable problems. A model with several targets may have no solution, one solution, or many possible solutions. Excel needs a clear objective and enough rules to determine which answer is acceptable.
Run Goal Seek in Excel for Microsoft 365
In Excel for Microsoft 365 on Windows, Goal Seek is on the Data tab. Before opening it, make sure the result cell contains a formula that depends on the input cell you want Excel to adjust. A typed value cannot be used as the result formula.
- Select the worksheet containing the formula and input.
- Choose Data > What-If Analysis > Goal Seek.
- In Set cell, enter or select the cell containing the formula.
- In To value, type the desired result as a number.
- In By changing cell, enter or select the one input cell Excel may adjust.
- Select OK to let Excel calculate, review the proposed result, and choose OK to keep it or Cancel to restore the previous value.
The set cell must contain a formula, and the changing cell must be an input that affects that formula. Goal Seek changes the input value; it does not rewrite the formula. On Mac, the command is also generally found under Data > What-If Analysis > Goal Seek, although the ribbon layout can vary by Excel build. Goal Seek is not provided as the same worksheet command in Excel for the web, so open the workbook in the desktop app if you need it.
A simple example: find a sales target
Suppose a sales worksheet calculates revenue from units sold and price per unit. Cell B2 contains units, cell B3 contains the price, and B4 calculates revenue. If B3 is 25 and you need revenue of 1,000, Goal Seek can find the required number of units by changing B2.
With price in B3 and units in B2, enter this formula in B4; at 40 units and a price of 25, it returns 1,000:
=B2*B3
Open Goal Seek, set cell B4 to 1000, and choose B2 as the changing cell. The solution is 40 units. This is a straightforward one-output, one-input problem, so Goal Seek is a good fit. In a real workbook, units may need to be whole numbers. Goal Seek does not enforce that rule, so you would need to check the result and round or use Solver with an integer constraint if whole units are essential.
Why one Goal Seek run cannot satisfy several goals
Each Goal Seek dialog accepts one set cell, one target value, and one changing cell. It has no field for a second result cell or a list of target values. Running it on one output and then running it on another does not make both targets simultaneous: the second run can change the input again and undo the first result.
There is also a mathematical limitation. One adjustable input generally cannot independently control multiple outputs. For example, if a single price affects both revenue and profit, the price that produces a chosen revenue may not also produce a separately chosen profit. This is not a missing Excel feature; the two requirements may conflict or require additional adjustable inputs.
Even when several changing inputs are available, the model may have more than one possible answer. A useful model therefore needs a selection rule, such as minimizing cost, maximizing profit, or keeping changes as small as possible. Without such a rule, “meet all goals” may not identify a unique result.
Use Solver for multiple changing cells or constraints
Solver is the usual Excel tool when a model has several decision cells, restrictions, or a single objective that depends on several calculations. It can change multiple cells and apply constraints such as a minimum, maximum, or integer requirement. It still works with one objective cell at a time; it is not a one-click command for specifying several independent target cells.
To use Solver in desktop Excel for Windows, first enable the add-in if needed: choose File > Options > Add-ins, select Excel Add-ins in the Manage box, click Go, check Solver Add-in, and click OK. Solver then appears under Data > Solver. The add-in setup and ribbon can differ on Mac.
For a model with several target outputs, one approach is to calculate the total squared difference between actual results and target results, then ask Solver to minimize that one error cell. For example, suppose inputs are in B2:B3, actual outputs are in D2:D3, and the corresponding target values are in C2:C3. With actual outputs in D2:D3 and targets in C2:C3, enter this in E2; it returns zero when both outputs exactly match their targets:
=SUMXMY2(D2:D3,C2:C3)
Set E2 as Solver’s objective and choose Min; set B2:B3 as the changing variable cells. If the model can reach both targets, the minimum error is zero. For example, if the two outputs are defined as the sum and difference of the inputs, targets of 10 and 2 have the solution 6 and 4: their sum is 10 and their difference is 2. If the targets conflict, the minimum error will remain above zero, which shows that the requested values cannot both be met exactly under the model.
Squared-error minimization is a modeling technique, not a special multi-target mode. It treats large misses more heavily than small ones, and targets with very different scales may dominate the total. If some goals matter more, the model needs appropriate weights or a different objective. Solver results should be checked against the original requirements and any constraints.
When repeated Goal Seek runs are enough
If each target belongs to a separate case, repeated Goal Seek runs can be practical. For example, you might calculate the price needed to reach a revenue target in January, then repeat the calculation for February using that month’s separate inputs. Keep each scenario’s inputs and outputs separate, or record the result before moving to the next case.
Do not assume that several sequential runs solve a simultaneous problem. If the same changing cell feeds all the target formulas, changing it for the second run changes the first result too. A simple test is to calculate every required output after the final run and compare each with its target. If one has drifted, the runs did not satisfy the goals together.
For many repetitive scenarios, a data table may be useful for showing how one or two inputs affect a formula across a range of values. In Excel, use Data > What-If Analysis > Data Table. A data table evaluates selected input values; it does not automatically search for a different solution for each of many targets. For fully automated repeated Goal Seek operations, VBA can call Goal Seek in a loop, but that requires a macro and careful handling of each scenario. Automation does not remove the need to verify whether the goals are compatible.
Goal Seek, Solver, and data tables compared
- Goal Seek: Best for one formula target and one adjustable input. It is quick to set up, but does not support multiple changing cells or explicit constraints.
- Solver: Best for an optimization model with one objective, multiple changing cells, and optional constraints. It can also minimize an error measure built from several target results.
- Data tables: Best for comparing calculated outcomes over a range of one or two input values. They show sensitivity, rather than solving a general multi-target model.
- Manual scenarios or formulas: Best when there are only a few cases, or when the equations can be solved directly and transparently.
For a simple one-variable calculation, start with Goal Seek rather than Solver. Move to Solver when you need multiple adjustable cells, limits, integer decisions, or a defined compromise among multiple results. Use a data table when the main question is “what happens across this range?” rather than “which input produces this exact target?”
Common problems and how to diagnose them
Goal Seek may fail to find an expected value or may return a surprising one. Check the structure of the model before repeatedly running the command.
- The set cell is not a formula: Goal Seek needs a calculated result, not a hard-coded value.
- The changing cell does not affect the result: Trace the formula references and confirm that changing the selected cell actually changes the set cell.
- The target is impossible: A formula may have a limited range. For instance, a probability formula cannot produce a value above 1 if it is defined to stay between 0 and 1.
- The formula is nonlinear or has multiple possible answers: Starting values can affect which solution Excel approaches. Try a reasonable starting value and verify the result in the model.
- The result is close but not exact: Goal Seek is an iterative numerical calculation. Display rounding can hide a small difference, so inspect the underlying value and the workbook’s calculation settings if precision matters.
- The model has hidden restrictions: Goal Seek does not enforce rules such as “input must be nonnegative” or “quantity must be an integer.” Check these manually or set them up as Solver constraints.
It is sensible to save the original input or make a copy of the worksheet before experimenting. Goal Seek changes a cell value, and keeping a record makes it easier to compare scenarios and restore the original assumptions.
Frequently Asked Questions
Can Excel Goal Seek change more than one cell?
No. Goal Seek accepts one changing cell per run. Use Solver when multiple input cells need to change to reach an objective.
Can I use Goal Seek for two target cells at once?
No. A Goal Seek run has one set cell and one target value. For multiple target outputs, use Solver with an objective such as total error, then check whether all targets can be met.
Can I run Goal Seek automatically for many rows?
Not as a built-in batch command in the Goal Seek dialog. For a small number of separate cases, run it repeatedly and record each answer. For larger workflows, a VBA macro can automate runs, but it must be designed and checked carefully.
Why does Goal Seek keep changing my first answer?
If you run Goal Seek again using the same input cell, the new run changes that cell again. Any earlier result that depends on it will change too. Separate scenarios into separate cells or use Solver to test simultaneous requirements.
Is Solver the same as multiple Goal Seek?
No. Solver can change multiple cells and optimize one objective under constraints. To handle several desired outputs, you can make a combined error formula the objective, but you must choose how to measure and prioritize the errors.
Related
- Import a CSV into an Existing Excel Workbook
- How to Compare Two Excel Sheets and Find Every Change
- How to Compare Two Excel Sheets
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Group Dates in Excel by Month, Quarter, or YearTo group dates in Excel, create a PivotTable, place the date field in Rows, then right-click a date…
- Compare Two Excel Sheets and Find Every DifferenceTo compare two Excel sheets, use a cell-by-cell formula when the rows line up, or match records by…
- Uniform Inventory Spreadsheet Template: What to TrackA uniform inventory spreadsheet template should track each uniform item by its type, size, color, location, and quantity—not…
- ISNUMBER in Excel: How It Works and When to Use ItIn Excel, use =ISNUMBER(A2) to check whether the value in cell A2 is a number; the result is…
- How to Run Goal Seek in Excel to Find a Target ValueTo run Goal Seek in Excel for Microsoft 365 on Windows, select the cell containing the formula you…
- Excel Mac Keyboard Shortcuts: Essential Keys and TipsIn Excel for Mac, use Command+C, Command+V, and Command+Z to copy, paste, and undo; use Command+Arrow to move…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.