Solver is a Microsoft Excel add-in program you can use for what-if analysis. Use Solver to 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.

This article discusses using Solver, a Microsoft Excel add-in program you can use for what-if analysis, to determine an optimal product mix. How can I determine the monthly product mix that maximizes profitability?

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.

Start using Solver to schedule your workforce in Excel. Learn how to use Excel's Solver add-in to create a staffing schedule based on your settings.

A Solver egy Microsoft Office Excel-bővítmény, mely választható a Microsoft Office és az Excel telepítésekor. Ha használni szeretné a Solver bővítményt, először be kell töltenie az Excelben.

By using Solver, you can find an optimal value for a formula in one cell—called the target cell—on a worksheet. Solver works with a group of cells that are related to the formula in the target cell.

Solver ist ein Add-In-Programm für Microsoft Excel, das Sie für Was-wäre-wenn-Analyse verwenden können. Verwenden Sie Solver, um einen optimalen (maximalen oder minimalen) Wert für eine Formel in einer Zelle zu finden – die als Zielzelle bezeichnet wird – vorbehaltlich von Einschränkungen oder Grenzwerten für die Werte anderer ...

If you know the result you want from a formula but aren't sure which input is needed to get that result, use Excel's Goal Seek feature.

Solver ajusta los valores de las celdas de variables de decisión para que cumplan con los límites de las celdas de restricción y den el resultado deseado en la celda objetivo. En resumidas cuentas, puede usar Solver para determinar el valor máximo o mínimo de una celda cambiando otras celdas.

A Scenario is a set of values that Excel saves and can substitute automatically on your worksheet. You can create and save different groups of values as scenarios and then switch between these scenarios to view the different results.