formulae

[Sparky AKA_Sparkticus]

=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

 

[Bob Phillips]

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


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Sparky AKA_Sparkticus]

=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

 

[Bob Phillips]

You didn't menyion E33 for Samsung. I assume you now mean this

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


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Sparky AKA_Sparkticus]

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