Using Solver

The Solver is similar to Goal Seek and scenarios, but provides more options to restrict the allowable range of values for different cells that can affect the goal. The Solver is an Excel add-in program, which may need to be loaded using the Add-In pane in Excel Options. The Solver is useful for predicting how results might change over time based on different assumptions. For example, suppose you have sales goals and quotas for the next three months. The Solver can take the expectations and the current quotas for each month, and determine how sales quotas for all three amounts be adjusted to achieve the goal.

Use Solver

Image Click the ...

Get Excel® 2013 On Demand 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.