Solver adjusts the values in the decision variable cells to satisfy the limits on constraint cells and produce the result you want for the objective cell. Put simply, you can use Solver to determine the maximum or minimum value of one cell by changing other cells.

How and when is the Solver add-in used in Excel?

The Solver Add-in is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel. To use the Solver Add-in, however, you first need to load it in Excel. , and then click Excel Options. Click Add-Ins, and then in the Manage box, select Excel Add-ins.

What is Solver in Excel with example?

Excel Solver allows specifying up to 200 variable cells. In this example, we have a couple of cells whose values can be changed: Projected clients per month (B4) that should be less than or equal to 50; and. Cost per service (B5) that we want Excel Solver to calculate.