• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Using Solver

Using a tool called Solver, Excel can find the optimal value for a formula (in the target cell) by systematically varying the values in a group of cells (called the changing cells) that reference or are referenced by the target cell. Solver can maximize (find the largest value), minimize (find the smallest value), or solve for a specific value of the target cell.

In the following example, we want to maximize annual profit (F7) by varying advertising expenditures. However, total advertising costs must be at least $25,000.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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