View Single Post
  #4   Report Post  
Harlan Grove
 
Posts: n/a
Default

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.