If cell NOT equal to 'this' OR 'that' then delete entire row

[terratushi]

Hi guys,

I have a simple line of code but not sure why it isn't doing what I want. I want to delete the entire row if the specified cell is NOT 'POD' or 'HUD'. I thought I had wrote it out correctly but it seems to delete every row no matter what the cell contains!

Please Login or Register  to view this content.

Any ideas?
Thanks

[BadlySpelledBuoy]

Should it be AND rather than OR?

BSB

[mike7952]

Try change Or to And.

Also

Please Login or Register  to view this content.

[terratushi]

Hi guys, I changed it to AND.. and now it works! Thanks :-)
But it seems strange to me that I'm using and since the cell isn't POD & HUD, it either contains POD or HUD or something else

[63falcondude]

The logic, in English, goes like this:

If the cell is not POD AND if the cell is not HUD, then delete row.


In mathematics:

~(A OR B) = ~A AND ~B

[terratushi]

Thanks guys :D

[63falcondude]

Glad we could help. Thanks for the rep!