Excel Solver Help

This web eBook provides Help for the basic Solver included with Excel 2010 and Excel 2013 for Windows and Excel 2011 for Mac, as well as the Solver App available for Office 365 and SharePoint 2013.

In Excel, Solver is part of a suite of commands sometimes called what-if analysis tools. With Solver, you can find an optimal (maximum or minimum) value for a formula in one cell — called the objective cell — subject to constraints, or limits, on the values of other formula cells on a worksheet. Solver works with a group of cells — called decision variable cells — that participate in computing the formulas in the objective and constraint cells. 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.

The objective, constraint and decision variable cells and the formulas interrelating them form a Solver model; the final values found by Solver are a solution for this model.  Solver uses a variety of methods, from linear programming and nonlinear optimization to genetic and evolutionary algorithms, to find solutions.