What's wrong with this IF statement?

[jasgot]

This doesn't work, how do I write it correctly?

If Range("b7").Value <> "Telephone Support" Or "Warranty Parts" Then


Thanks....
Jason

 

[texasalynn]

On 2002-07-26 10:12, jasgot wrote:
This doesn't work, how do I write it correctly?

If Range("b7").Value <> "Telephone Support" Or "Warranty Parts" Then


Thanks....
Jason

TRY THIS:
if(or(b7<>"Telephone Support", b7<>"Warranty Parts"),"Good","Bad")

HTH
texasalynn

 

[Barrie Davidson]

On 2002-07-26 10:12, jasgot wrote:
This doesn't work, how do I write it correctly?

If Range("b7").Value <> "Telephone Support" Or "Warranty Parts" Then


Thanks....
Jason

Try

If Range("b7").Value <> "Telephone Support" Or <> "Warranty Parts" Then

Regards,

 

[OdinsDream]

I've always had this problem, and have solved it by simply doing:

If Range("b7").Value<> "Telephone Support" Or Range("b7").Value<> "Warranty Parts" Then

So, you can't just string OR's on to the end, it has to be comparing directly.
This message was edited by OdinsDream on 2002-07-26 10:46