using solver question

  • Thread starter Thread starter jvc007
  • Start date Start date
J

jvc007

How do you perform and inclusive or test using solver. I need Y1 to equal 1
if x11 or x21 is greater than o and Y1 to equal zero if both x11 and x21
equal zero
using solver: if x11 or x21 >= 0 then y1=1 otherwise y1=0
 
How do you perform and inclusive or test using solver. I need Y1 to equal 1
if x11 or x21 is greater than o and Y1 to equal zero if both x11 and x21
equal zero
using solver: if x11 or x21 >= 0 then y1=1 otherwise y1=0
Click to expand...

Why particularly do you want to use Solver? A formula in Y1 would
work.
=IF(OR(X11>0,X21>0),1,0)
 
.... or just =--OR(X11>=0,X21>=0)

(note that I changed > to >=, as that was what the OP asked for)
 
(note that I changed > to >=, as that was what the OP asked for)

Well, the written part says one thing, and the last line says
something different. I looked at that a bit before posting and decided
no "=" was appropriate, but the OP will have to figure it out.
 
Back
Top