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

Using the Solver Add-In

The Solver Add-In is part of a suite of commands sometimes called what-if analysis tools. With Solver, you can find an optimal value for a formula in one cell—called the target cell—on a worksheet. Solver works with a group of cells that are related, either directly or indirectly, to the formula in the target cell. Solver adjusts values in cells you specify—called the adjustable cells—to produce the result you specify from the target cell formula. You can apply constraints to restrict the values Solver can use in the model, and the constraints can refer to other cells that affect the target cell formula.

You can use Solver to determine the maximum or minimum value of one cell by changing other cells—for example, you can change the amount of your projected advertising budget and see the effect on your projected profit.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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