• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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. For more information running Setup, see Appendix A, “Installing Microsoft Excel.”



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint