SOLVER.DELETE

Macro Sheets Only

Equivalent to choosing the Solver command from the Tools menu and choosing the Delete button in the Solver Parameters dialog box. Deletes an existing constraint.

If this function is not available, you must install the Solver add-in macro.

Syntax

SOLVER.DELETE(cell_ref, relation, formula)

For an explanation of the arguments and constraints, see SOLVER.ADD.

Remarks

If the combination of cell_ref and relation does not match any existing constraint, the function returns the value 4 and no action is taken. If the constraint is found, it is deleted, and the function returns the value 0.

Related Functions

SOLVER.ADD Adds a constraint to the current problem

List of Command-Equivalent Functions