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

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.