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
|