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