Using the Solver

image with no caption

The Goal Seek command is handy for problems that involve an exact target value that depends on a single unknown value. For problems that are more complex, you should use the Solver add-in. The Solver can handle problems that involve many variable cells and can help you find combinations of variables that maximize or minimize a target cell. It also specifies one or more constraints—conditions that must be met for the solution to be valid.

Note

The Solver is an add-in. If the Solver button does not appear on the Data tab on the ribbon, click the File tab, Options, Add-Ins category, and then click the Go button. Select the Solver Add-In ...

Get Microsoft® Excel® 2010 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.