That work great i tried all sorts of variations to do that but had no luck.
did it with vba in the end but your code works brill and a lot easier then
the vba method

sparky

Bob Phillips wrote:
You didn't menyion E33 for Samsung. I assume you now mean this

=IF(OR(AND(E33=32,E34="RELISYS"),AND(E33=32,E34="S AMSUNG")),1,""))



"Sparky AKA_Sparkticus" wrote in
message . uk...
Bob Phillips wrote:
=IF(OR(AND(E33=32,E34="RELISYS"),E34="SAMSUNG"),1, ""))


Thanks for your reply, the first part works ok but samsung get the
answer 1
no matter what number is in e33.

sparky

--

There's no underestimating the intelligence of the American public.
H. L. Mencken (1880 - 1956)