Excel Goal Seek Maximum Value: Find the Actual Maximum

How-to basics · Updated November 19, 2026

Excel Goal Seek cannot find the maximum value of a formula by itself: it finds an input that makes a formula equal a target you specify. To maximize a result, use Solver instead: choose the result cell as the objective, select Max, and tell Solver which input cells it may change.

What Goal Seek Does—and What It Does Not Do

Goal Seek is Excel’s single-variable what-if analysis tool. You give it a formula cell, a desired result, and one input cell to adjust. Excel changes that input iteratively until the formula is close to the target, if it can find a solution. For example, you can ask what sales quantity would make a profit formula return 1,200.

That is different from asking Excel to find the largest possible profit. A target is a value you already know and want to reach; a maximum is the best result across the permitted choices. Goal Seek has no Max option, does not compare all possible inputs, and does not accept constraints such as a minimum quantity or a capacity limit. It may find an input that reaches a target without finding the best input for the objective.

This distinction matters because a formula can reach the same target at more than one input. A curved profit formula, for instance, might produce a target profit once on the way up and again on the way down. Goal Seek returns a solution, not a report of every solution or proof that the result is optimal.

Use Solver to Maximize a Formula

Solver is the Excel feature designed to maximize or minimize an objective while changing selected cells and, when needed, respecting constraints. In Excel for Microsoft 365 on Windows, Solver is an add-in. If the Solver command is absent from the Data tab, enable it by going to File > Options > Add-ins. At the bottom, set Manage to Excel Add-ins, select Go, check Solver Add-in, and select OK. The Solver command should then appear in the Analysis group on the Data tab.

For a simple example, suppose B2 contains the number of units and B3 calculates profit. Assume the illustrative profit rises with sales at first but eventually falls as a quadratic cost increases. With the quantity input in B2 and the profit result in B3, enter this formula in B3:

=100*B2-2*B2^2

This simplified example is only for demonstrating spreadsheet optimization, not business or financial advice. If B2 is 25, the result is 100 times 25 minus 2 times 25 squared: 2,500 minus 1,250, or 1,250. The peak occurs at 25 units in this example.

To ask Solver to find that peak:

  1. Choose Data > Solver.
  2. In Set Objective, select B3, the cell containing the profit formula.
  3. Select Max to maximize the objective.
  4. In By Changing Variable Cells, select B2.
  5. Add a constraint that B2 is greater than or equal to 0 if negative quantities are not allowed. Add other real limits, such as available capacity, if they apply.
  6. Choose Solve, review the result, and select Keep Solver Solution if it is acceptable.

With the stated formula and a nonnegative quantity, the maximum is 1,250 at B2 equal to 25. Solver is not simply returning a target chosen in advance; it is searching for the input that optimizes the objective under the supplied model and limits.

When Goal Seek Is Still the Right Tool

Goal Seek is useful when the question is about a particular outcome rather than the best outcome. Examples include finding the number of items needed to break even, the test score needed to reach a course average, or the interest rate that produces a specified payment in a worksheet model. In each case, the formula and target are known, and there is one input to adjust.

In the profit example, asking for profit of 1,200 is a valid Goal Seek question. That target occurs at both 20 and 30 units: at 20, the calculation is 2,000 minus 800; at 30, it is 3,000 minus 1,800. Which answer Goal Seek finds can depend on the starting value in B2. Either answer reaches the target, but neither is the maximum of 1,250.

This is a common source of confusion: reaching a high target does not establish that the result is the highest possible value. Goal Seek is appropriate when you have a desired number to hit. Use Solver when you want the best value and need Excel to search for it.

Set Up the Model Before Optimizing

Solver can only optimize the model represented by the worksheet. Before opening it, separate decision inputs from calculated results, check that formulas refer to the intended cells, and make the units clear. In the example, B2 is a quantity that Solver may change, while B3 is calculated from B2. The objective should be the formula result, not the input cell.

Then translate real-world rules into constraints. If quantities must be whole units, add an integer constraint. If production cannot exceed 40 units, set the input to be less than or equal to 40. If two products share a limited resource, the model may need multiple changing cells and a formula for total resource use, constrained by the available amount. A constraint should reflect an actual limit, not a value added just to force a preferred answer.

Check that each constraint uses compatible units and has the right direction. A capacity limit is usually an upper bound; a minimum service requirement is usually a lower bound. If a constraint conflicts with another, Solver may report that it cannot find a feasible solution. That means no combination of the selected changing cells satisfies all specified rules, not necessarily that Excel is malfunctioning.

Choose a Solver Method and Interpret the Result

Solver offers different solving methods because models behave differently. For smooth formulas with continuous inputs, GRG Nonlinear is often a suitable starting point. For a linear objective and linear constraints, Simplex LP is designed for linear programming. Evolutionary can be useful for models with discontinuities or formulas that do not behave smoothly, though it can take longer and may not identify a global best answer.

A Solver result should be treated as a result for the model and method used, not as proof that every real-world possibility has been examined. Nonlinear problems can have multiple peaks. A method may find a nearby local maximum rather than the highest maximum overall, particularly when the starting values matter. Try sensible alternative starting values and compare the outcomes when the problem is nonlinear. For integer or binary decisions, confirm that the appropriate constraints are included.

After Solver finishes, inspect the changing cells, objective value, and constraints. Check that the selected result makes practical sense and that no input moved outside a valid range. Keep a copy of the original inputs or save a version of the workbook before solving, especially if you need to compare assumptions. A mathematically optimal answer can still be misleading if the formula, data, or constraints do not represent the situation accurately.

Other Ways to Find a Maximum

Solver is not the only option. If the decision is limited to a short list of known alternatives, calculate the objective for each alternative and compare the results. For instance, a table of candidate quantities can show the corresponding profit for each quantity; the largest result in that table is the maximum among those candidates. This is transparent and works well when the alternatives are discrete or when you want to see how the result changes across a range.

Excel’s one-variable Data Table can evaluate a formula for a series of input values. Find it through Data > What-If Analysis > Data Table. A table can reveal where a result appears to peak, but its conclusion depends on the inputs you include and the step size. If the best value lies between two tested values, a coarse table can miss it. Use a finer interval around a promising area, or use Solver when you need a constrained optimization rather than a scan of selected values.

For a simple formula with a known mathematical shape, algebra or calculus may identify its maximum directly. That can be a useful independent check on Solver, as in the quadratic example. In practical worksheets with many linked formulas and business rules, however, deriving the answer by hand may be less convenient than setting up Solver and validating the model.

Windows, Mac, and Excel for the Web

The steps above describe Excel for Microsoft 365 on Windows. On a Mac, Solver is also an Excel add-in; enable it from Tools > Excel Add-ins by selecting Solver Add-in. The exact placement of commands can vary by interface, but the Solver dialog uses the same basic objective, changing cells, and constraints approach. Goal Seek is available from the Data tab’s What-If Analysis options in desktop Excel.

Excel for the web does not provide the desktop Solver add-in workflow described here. If your workbook needs Solver, open it in the desktop version of Excel. A workbook may still be viewable or editable in a browser, but do not assume that the web version can run the same optimization steps as desktop Excel.

Common Problems to Check

  • Solver is missing: Check whether the Solver Add-in is enabled in Excel’s add-ins settings, then look on the Data tab.
  • The objective does not change: Confirm that the objective formula actually depends on at least one changing cell. A disconnected cell gives Solver nothing to optimize.
  • The answer is surprising: Check the formula, starting values, units, and constraints. Also consider whether the model has more than one local optimum.
  • Solver reports no feasible solution: Review constraints for contradictions, reversed inequality directions, or limits that cannot all be met together.
  • Goal Seek returns an unexpected root: The formula may have several inputs that produce the target. Try another starting value or use Solver or a table to investigate the alternatives.

When a result is important, verify it independently. Substitute the proposed input into the worksheet, inspect the resulting objective, and test nearby alternatives. For a maximum, nearby values should not produce a better result within the same permitted range. This simple check can expose a mistaken constraint or a search result that needs further investigation.

Frequently Asked Questions

Can Excel Goal Seek find the maximum value?
No. Goal Seek finds an input that makes a formula reach a specified target. To maximize a formula, use Solver and select Max for the objective cell.

How do I maximize a cell in Excel?
Make sure the cell contains the result formula, open Data > Solver, set that cell as the objective, choose Max, select the input cells Solver may change, add applicable constraints, and choose Solve.

Why does Goal Seek give different answers for the same target?
A formula can reach one target at multiple input values. Goal Seek starts from the current input and searches for a solution, so a different starting value may lead it to a different valid answer.

Can Goal Seek change more than one cell?
No. Goal Seek adjusts one changing cell. Solver supports multiple changing cells and constraints, so it is the appropriate built-in tool for more complex optimization models.

Is Solver included with Excel?
Solver is an Excel add-in available in desktop Excel, but it may need to be enabled before its command appears. In Excel for the web, use desktop Excel for the Solver workflow described above.

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.