I have never faced that one.
I suppose Solver developers might say: "how much greater" is "greater?
After all Solver works with in limits. A1=B1 can pass if A=1 and B1=1.00001
when Precision is 0.00001.
I would try one of these:
A1=B1+2 (or some other constant)
or
A1 X1 where X1 =B1 + 2
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"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.