formulae
 

=IF(E34="RELISYS",1,(IF(E34="SAMSUNG",1,""))

I have this formula for a spread sheet, but need to include cell e33's value
into it so if it is a relisys and is e33 = 32 i get the 1 value but all i
can seem to get is true or false is there another way???

sparky

formulae
 

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


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Sparky AKA_Sparkticus" wrote in message
. uk...
=IF(E34="RELISYS",1,(IF(E34="SAMSUNG",1,""))

I have this formula for a spread sheet, but need to include cell e33's
value
into it so if it is a relisys and is e33 = 32 i get the 1 value but all i
can seem to get is true or false is there another way???

sparky

formulae
 

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

formulae
 

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,""))


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"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

formulae
 

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)