View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
monir monir is offline
external usenet poster
 
Posts: 215
Default Comparison Operator "" NOT "="

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.