About the Solver Parameters dialog box

Set Target Cell

Specifies the target cell that you want to set to a certain value or that you want to maximize or minimize. This cell must contain a formula.

Equal to

Specifies whether you want the target cell to be maximized, minimized, or set to a specific value. If you want a specific value, type it in the box.

By Changing Cells

Specifies the cells that can be adjusted until the constraints in the problem are satisfied and the cell in the Set Target Cell box reaches its target. The adjustable cells must be related directly or indirectly to the target cell.

Guess

Guesses all nonformula cells referred to by the formula in the Set Target Cell box, and places their references in the By Changing Cells box.

Subject to the Constraints

Lists the current restrictions on the problem.

Add

Displays the Add Constraint dialog box.

Change

Displays the Change Constraint dialog box.

Delete

Removes the selected constraint.

Solve

Starts the solution process for the defined problem.

Close

Closes the dialog box without solving the problem. Retains any changes you made by using the Options, Add, Change, or Delete buttons.

Options

Displays the Solver Options dialog box, where you can load and save problem models and control advanced features of the solution process.

Reset All

Clears the current problem settings, and resets all settings to their original values.