View Single Post
  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

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