This normally means you are missing a constraint (or multiple constraints) that is allowing the objective to go to positive or negative infinity.
For example:
Set A1 as a variables
Set A2 as = A1 * 2
Set A2 as the objective to maximize
When you run this, you should get that same error message, since A1 is not restricted and A2 can potentially become positive infinity.
Please check your constraints and ensure the objective is not being allowed to range from positive to negative infinity. You can also run a quick test by applying a constraint directly to your objective cell which should also resolve the error but is not generally good modeling practice unless you have known minimum or maximum value for it to be.
Comments
0 comments
Please sign in to leave a comment.