## Related Tutorials

Excel > Excel 2007 Advanced > What-If Analysis

# Solver

Solver is a tool that can solve complex problems using multiple variables. Solver can also handle constraints that need to be met.

Solver is an Excel add-in. This needs to be installed before you can use Solver.

1. Click the Office Button and then click the Excel Options button
2. Click Add-Ins from the list on the left
3. If necessary, click the Manage list arrow and select Excel Add-ins
4. Click the Go button
5. The Add-Ins dialogue box is displayed, showing a list of available Excel add-ins.

6. Click the Solver Add-in check box to select it
7. Click Ok

The Solver tool is now available in the Analysis group of the Data tab on the Ribbon

## Using Solver

Let's use Solver to find out the maximum revenue we can make in one evening for a theatre production based on the tickets prices and some constraints

For Solver to present a solution it needs certain items of information from us.

.
• Target Cell: The cell where the result will appear. This cell must contain a formula.
• Changing Cells: The cells containing the variable values that Solver will update whilst trying to calculate the result
• .
• Constraints cells: Cells containing values used in conditions that need to be met

Before running Solver, ensure that all the data needed is on the sheet. This includes the formula in the target cell, cells for changing cells and the constraints.

The data used in the following example can be seen below

1. Click on the Solver button in the Analysis group of the Data tab
2. The Solver Parameters dialogue box appears

3. In the Set Target Cell field, select the cell where the maximum revenue will appear
4. Select an Equal To option button for the target you wish to achieve. You can specify a specific value in the Value of field, or choose to find the maximum or minimum value as used in this example
5. Enter the cells whose value must change to produce the result in the By Changing Cells field