High School

Nonlinear engine for Solver problems that are smooth nonlinear. Select the LP engine for linear Solver problems, and select the Evolutionary engine for Solver problems that are non-smooth.

Task Instructions:
Add a constraint to the current Solver model specifying that 30 is the maximum value for cell C11.

Answer :

To add a maximum value constraint to Solver, launch Solver from the Data tab, click Add, select cell C11, use the \<= operator, enter 30 as the constraint, and click OK to apply.

To add a constraint to the current Solver model specifying that 30 is the maximum value for cell C11, you should follow these instructions:

  1. Reset the initial values to 1 and 20, then launch Solver (click the Data tab and click Solver).
  2. Click the Add button to open the Add Constraint dialog box.
  3. In the Cell Reference field, select cell C11.
  4. Select <= as the operator.
  5. Enter 30 in the Constraint field.
  6. Click OK to add the constraint.
  7. Back in the Solver Parameters dialog box, you can now click Solve to solve the model with the new constraint applied.

Other Questions