using solver question
 

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

using solver question
 

On Aug 4, 2:18 pm, jvc007 wrote:
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

Why particularly do you want to use Solver? A formula in Y1 would
work.
=IF(OR(X110,X210),1,0)

using solver question
 

.... or just =--OR(X11=0,X21=0)

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

"Spiky" wrote in message
...

Why particularly do you want to use Solver? A formula in Y1 would
work.
=IF(OR(X110,X210),1,0)

On Aug 4, 2:18 pm, jvc007 wrote:
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

using solver question
 

(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.