When using Solver to find a solution for an LP problem, both the left-hand side and the right-hand side of your constraints must be a formula calculated using the cells containing the decision variables.

Question

Quizplus · Accepted Answer

In Solver for LP problems, the left-hand side (LHS) of the constraints often involves formulas using the decision variables, but the right-hand side (RHS) can be constants or directly entered values, not necessarily formulas.

When Using Solver to Find a Solution for an LP