Syntax for 2 AND conditions within an OR function.
 

Greetings all,

I'm close, I think.
I need to OR two AND conditions. The 60/45 and 12/40 are text formatted

A1 A2
"60/45" AND "Green"
OR
A1 A2
"12/40" AND "Red"

True = YES
False = NO

Thanks Folks!

Mike

=if(or(and(a1="60/45" ,a2= "Green"),and(a1="12/40",a2= "Red")),"yes","no")


"Mike K" wrote:

Greetings all,

I'm close, I think.
I need to OR two AND conditions. The 60/45 and 12/40 are text formatted

A1 A2
"60/45" AND "Green"
OR
A1 A2
"12/40" AND "Red"

True = YES
False = NO

Thanks Folks!

Mike

or

=IF(OR(A1&A2="60/45Green",A1&A2="12/40Red"),"yes","no")

--
HTH

Bob Phillips

"Duke Carey" wrote in message
...
=if(or(and(a1="60/45" ,a2= "Green"),and(a1="12/40",a2= "Red")),"yes","no")


"Mike K" wrote:

Greetings all,

I'm close, I think.
I need to OR two AND conditions. The 60/45 and 12/40 are text formatted

A1 A2
"60/45" AND "Green"
OR
A1 A2
"12/40" AND "Red"

True = YES
False = NO

Thanks Folks!

Mike

Bob Phillips wrote...
or

=IF(OR(A1&A2="60/45Green",A1&A2="12/40Red"),"yes","no")
....
"Duke Carey" wrote in message
=if(or(and(a1="60/45" ,a2= "Green"),and(a1="12/40",a2= "Red")),"yes","no")
....

In this particular case concatenation works, but it isn't reliable in
general.

Harlan,

Are you referring to numbers?

Bob

"Harlan Grove" wrote in message
oups.com...
Bob Phillips wrote...
or

=IF(OR(A1&A2="60/45Green",A1&A2="12/40Red"),"yes","no")
...
"Duke Carey" wrote in message
=if(or(and(a1="60/45" ,a2= "Green"),and(a1="12/40",a2=
"Red")),"yes","no")
...

In this particular case concatenation works, but it isn't reliable in
general.

Bob Phillips wrote...
Are you referring to numbers?
....

No. The result of the concatenation operator, &, is always text.

But the point is that using OR(x&y="foobar",x&y="doodah") when the
fully qualified test is OR(AND(x="foo",y="bar"),AND(x="doo",y="dah"))
can lead to error when, e.g., x = "foob" and y = "ar" or x = "do" and y
= "odah". IOW, x&y=A&B doesn't necessarily give the same result as
AND(x=A,y=B).