Goal Seek on Multiple Cells in Excel: What Works?

How-to basics · Updated November 21, 2026

No: Excel’s Goal Seek can adjust only one changing cell to make one formula cell reach a specified value. If you need Excel to change several input cells at once, use Solver instead; if you are comparing scenarios, a data table or separate Goal Seek runs may be more suitable.

What Goal Seek can and cannot change

Goal Seek is Excel’s built-in tool for working backward from a desired result. You tell it which formula cell to set, what value that formula should return, and which single input cell Excel may change. Excel then tries different values in that input cell until the formula is close to the target.

The one-cell limit applies to the changing cells, not to the number of cells involved in the calculation. A formula can depend on many cells, and changing one of them can affect a large model. But Goal Seek cannot choose values for two or more independent inputs together. Nor can you enter a range such as B2:B5 as its changing cell.

For example, Goal Seek can adjust a unit price to reach a revenue target when the number of units is fixed. It cannot simultaneously choose both a price and a quantity to reach that revenue. That distinction matters: the first question has one unknown, while the second has multiple possible combinations.

How to run Goal Seek in Excel for Microsoft 365

On Excel for Microsoft 365 for Windows, set up a formula that calculates the result you want to control. Then use Data > What-If Analysis > Goal Seek. In the dialog, fill in the result cell, target value, and the one input cell Excel is allowed to change.

  1. Choose a cell containing a formula for the outcome you want, such as revenue or profit.
  2. Open Data > What-If Analysis > Goal Seek.
  3. In Set cell, select the formula cell. In To value, type the target number.
  4. In By changing cell, select one input cell that the formula depends on.
  5. Select OK to let Excel calculate. Review the proposed value, then choose OK to keep it or Cancel to restore the earlier value.

For example, suppose B2 contains a unit price of 18, B3 contains 400 units, and B4 is the revenue result. With that layout, enter this formula in B4: =B2*B3. To find the price that produces revenue of 10,000, set B4 to 10000 by changing B2. The result is 25, because 25 multiplied by 400 equals 10,000. B3 remains fixed throughout the calculation.

Goal Seek changes the selected input cell’s value; it does not rewrite the formula in the result cell. Before accepting the result, check that the changed input is still sensible for your model. If your input is subject to limits, such as a minimum price or a whole-number quantity, Goal Seek does not provide the same constraint controls as Solver.

Why several changing cells require Solver

Solver is the Excel add-in designed for problems that may involve multiple decision cells and constraints. Instead of asking Goal Seek to change one input, Solver can optimize an objective cell by changing a range of cells. You can also specify restrictions, such as requiring a quantity to be a whole number or keeping an expense below a limit.

To use Solver on Windows, first enable the add-in if it is not already available: select 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 under Data > Solver.

Imagine a model where B2 is price, B3 is quantity, and B4 calculates revenue. With those cells, the formula in B4 is =B2*B3. If the task is simply to make B4 equal 12,000 by changing both B2 and B3, many combinations work: 20 and 600, 30 and 400, or 40 and 300. The target alone does not identify a unique answer.

That is why a multi-cell problem usually needs a clearer objective or additional constraints. You might ask Solver to maximize profit while keeping price at or below a stated ceiling and quantity within available capacity. Solver can then search for values that satisfy the conditions and improve the chosen objective. The results depend on the model, constraints, and Solver method; they are not automatically a business recommendation.

Solver is available in Excel desktop applications, but it is not the same feature as Goal Seek and is not available to run in Excel for the web. In Excel for Microsoft 365 for Mac, Solver can be enabled through Tools > Excel Add-ins, then selected from the Data tab. Ribbon wording or placement can vary with updates, so check the Data tab after enabling the add-in.

Choose the right tool for the question

The best option depends on what you are trying to find. Using the wrong tool can produce a number that looks precise but does not answer the actual question.

  • Goal Seek: Use it when one formula needs to reach one target by changing one input, such as finding the price that gives a specified revenue at a fixed sales volume.
  • Solver: Use it when several inputs may change, or when the solution must meet constraints, such as production limits or whole-number requirements.
  • Data tables: Use a one-variable or two-variable data table when you want to compare how a formula’s results change across a set of trial inputs. A data table evaluates scenarios; it does not search for the best solution across an arbitrary number of variables.
  • Separate Goal Seek runs: Use these for independent questions, each with its own target and one changing input. Record the results if you need to compare them.

For instance, a two-variable data table can show revenue at a grid of different prices and quantities. That is useful for seeing a range of outcomes, but it does not mean Goal Seek has become a multi-cell solver. If you need Excel to select inputs under restrictions, Solver is the more relevant tool.

Multiple targets are a different problem

Readers sometimes mean several target cells when they ask about Goal Seek on multiple cells. Goal Seek handles one Set cell and one target value in each run. It does not set several formulas to separate targets in one operation.

You can run it repeatedly for different targets, but each run changes a cell value. If later runs use the same input cell, they can replace the result of an earlier run. Keep a copy of the original inputs or record each result in a separate scenario table. If several targets must be satisfied at the same time, determine whether your model has enough independent inputs and whether the targets are compatible. Solver may help with simultaneous conditions, but a system with conflicting or insufficiently defined conditions may have no unique solution.

A related misconception is that Goal Seek can find any requested target if you enter it correctly. It is an iterative calculation, so results depend on the model’s behavior and starting value. A formula may have no solution, more than one possible solution, or a solution that is impractical. Always confirm that the returned value makes sense when you recalculate the model.

Common problems and practical checks

If Goal Seek does not return the expected answer, first confirm that Set cell contains a formula and that the changing cell is an input used by that formula. A fixed number in the result cell gives Excel nothing to recalculate, and changing a cell that the formula does not reference cannot move the result.

  • Result is close, not exact: Goal Seek uses iterative calculations and may stop near the target. Check the difference between the formula result and the target, and consider whether that precision is sufficient for the task.
  • No useful result appears: Check for formula errors, invalid inputs, or a target that the model cannot reach. Try a reasonable starting value for the changing cell and verify the model with a few manual input changes.
  • The answer is unrealistic: Goal Seek does not know real-world limits unless they are built into the model. It can return a negative price or a fractional number of items if the formulas allow it.
  • Several values need limits: Use Solver when you need to apply constraints to multiple changing cells rather than relying on Goal Seek.
  • Results change unexpectedly: Check whether formulas depend on other cells that were changed during previous attempts, and restore the intended starting assumptions before comparing scenarios.

For money or business models, label assumptions clearly and distinguish inputs from calculated results. A target generated from an illustrative model is only as reliable as its assumptions. For a loan, budget, or other financial calculation, verify the actual terms and assumptions with the lender or a qualified professional; a spreadsheet result is not financial advice.

Excel desktop, Mac, and web differences

In Excel for Microsoft 365 on Windows, Goal Seek is in Data > What-If Analysis > Goal Seek. Excel for Microsoft 365 for Mac also includes Goal Seek, though the ribbon can look different; look on the Data tab for What-If Analysis and Goal Seek. Solver on Mac must be enabled separately as an Excel add-in.

Excel for the web does not provide the desktop Goal Seek command for running this analysis. If a workbook needs Goal Seek or Solver, open it in the Excel desktop app. A workbook may still contain formulas and values that can be viewed or edited in the browser, but that is different from running these what-if tools there.

These tools are built into or provided as add-ins for desktop Excel, so there is no separate purchase required just to use Goal Seek in an eligible desktop installation. Availability of Solver depends on enabling its add-in. If you are using a managed work or school installation and cannot find a feature, an administrator’s configuration or the installed Excel version may be relevant.

Frequently Asked Questions

Can Goal Seek change two cells at once?
No. Each Goal Seek run accepts one changing cell. Use Solver if you need Excel to adjust multiple decision cells together.

Can I run Goal Seek on several rows?
Not as one batch operation using the Goal Seek dialog. You can run it separately for each row, or consider Solver, a data table, or an automated approach if the rows form a repeatable model.

Can Goal Seek make several formula cells equal different targets?
No. It works with one formula cell and one target per run. If all targets must be met at the same time, model the conditions and consider Solver, while checking that the problem has a feasible solution.

Does Goal Seek work in Excel for the web?
No. Use the Excel desktop app for Goal Seek. The web app can handle many workbook tasks, but it does not run the desktop Goal Seek command.

Why does Goal Seek give a value that seems wrong?
It may be finding a mathematically valid value that violates a practical limit, or the target may be unreachable or have multiple solutions. Check the formulas, starting value, and assumptions; use Solver when constraints are part of the problem.

Related

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.