Using the Solver
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 you performed a full installation of Excel, the Tools menu includes the Solver command. If you don't find that command on the Tools menu, choose Tools, Add-Ins, and then select Solver Add-In in the Add-Ins list. If Solver isn't in the list, you'll need to rerun Setup. ...
Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
