The operator "=" is a 2-in-1 condition: greater than OR equal to.
Instead of the desired constraint A1 B1, if you spesify A1 =
B1+something, you're actually adding a constraint A1=B1+something, which
doesn't exist and causes Solver to fail.
For the current Solver optimization scenario to be successful, it must
satisfy the constraint A1 B1 (together with the other specified
constraints).
Depending on the problem parameters, a successful solution by Solver could
yield a value in A1 that's a fraction or many order of magnitude greater than
the value in B1.

Any suggestion ?? Thanks.


"Tyro" wrote:

You can specify a constraint such as A1 = B1 + 1 (or B1 + .00000001). That
makes the constraint A1 B1

Tyro

"monir" wrote in message
...
Hello;
I was a bit hesitant to post this question for obvious reasons, but I
decided to post it anyway!! You never know!
The Excel add-in Solver module has the following comparison operators to
choose from in "Subject to the Contraints" box:
<= , = , = , int(eger) , bin
One may choose one or more operators from the above list.

I need to specify the constraint: A1 B1

Is there a workaround this difficulty ???
(choosing the constraint A1 = B1 appears to force Solver to first try A =
B
and fails)

Thank you.