1 overview

Solver is part of a set of commands, which are sometimes called what-if analysis (what-if analysis: the process of changing values in cells to see how these changes affect the results of formulas in a worksheet. For example, changing the interest rate in the installment plan can adjust the payment amount. ) tools. With the help of Solver, you can find a formula (formula: a combination of a series of values, cell references, names or operators) in a cell (called the target cell) on the worksheet, and you can generate new values. Formulas always start with an equal sign (=). The optimal value of). Solver will adjust the values in a group of cells directly or indirectly related to the formula in the target cell, and finally get the expected results in the formula in the target cell. Solver finds the desired result from the target cell formula by adjusting the value in the specified variable cell (variable cell). In the process of creating a model, you can apply constraints (constraints: constraints set in Solver) to variable cell values in Solver models. Constraints can be applied to variable cells, target cells, or other cells that are directly or indirectly related to the target cells. ), and constraints can refer to other cells that affect the target cell formula.

Use Solver to determine the maximum or minimum value of a cell by changing other cells. For example, you can change the planned advertising budget to see the impact on the planned revenue.

2 planning solutions in Excel software

In EXCEL, an important component of OFFICE, there is an add-in for programming. After adding the macro, you can use EXCEl's planning solution function to solve the planning.

Load solution macro

In EXCEL2003, you can load a macro by clicking Menu Tools-Macros-Add-ins and loading the Solver Add-in.

In EXCEl2007, you can load Solver macro by clicking the office button, converting EXCEl Options-Add-ins into EXCEL Add-ins, and then loading Solver Add-ins.

In EXCEl version EXCEl20 10, click the File tab to open the Excel Options dialog box, click the Add-in tab on the left, click the Go button on the right to open the Add-in dialog box, select the Solver Add-in box, and then click the OK button to display it in the data tab of the toolbar.