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

Part V: Analyzing the Worksheet > Solving with Goal Seek and Solver

Chapter 31. Solving with Goal Seek and Solver

  • Use Goal Seek

    Tools, Goal Seek allows you to solve for a single input cell.

  • Move chart markers

    Solve for an input cell by moving a point on a chart.

  • Apply Solver

    Use Solver to find the best allocation of limited resources.

  • Use integer constraints

    Handle fixed costs and yes/no decisions in Solver models.

  • Save Solver problems

    Save multiple problems and transfer them between spreadsheets.

Excel provides many tools to help you analyze data on worksheets. Two powerful examples of these tools are the Tools, Goal Seek command and the Solver add-in. The Goal Seek command finds the input value that produces the answer you want in a formula cell. Solver is a tool that finds the best or optimal values for several inputs, producing answers that satisfy limits on certain formula cells called constraints, while maximizing or minimizing a specific formula cell, called the objective.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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