To force a variable X to be a whole number in an optimization model, we would ha
ID: 3012976 • Letter: T
Question
To force a variable X to be a whole number in an optimization model, we would have to
Add the constraint X > 0 to the model.
Use the formula IF(X > 0, "integer", 0) in the Excel model.
Set X as "int" in the Solver Add Constraint dialog.
Set X as "bin" in the Solver Add Constraint dialog.
Add the constraint X > 0 to the model.
Use the formula IF(X > 0, "integer", 0) in the Excel model.
Set X as "int" in the Solver Add Constraint dialog.
Set X as "bin" in the Solver Add Constraint dialog.
Explanation / Answer
1. Add the constraint X > 0 to the model.
Because whole numbers are numbers without fraction, negatives or decimals I.e (0,1,2.......) are whole numbers. Sonsetting X as " int " makes it integers which we don't want and setting X as " bin " makes it binary I.e 0,1 only.