Forum Discussion
Advanced Filtering, When to use AND/ OR?
Hi everyone,
I wanted to exclude some data where certian colours appear.
What is the difference between using the AND operator and the OR operator when used in the following context below?
I want to exclude all of the colours seen:
If I use OR instead of AND, what will the outcome be?
Thanks
Anonymous And is fine with not in.
For same value or is like in. [Col] ="A" or [COl] = "B" means [col] in {"A", "B"}
but you can not have
[Col] ="A" and [COl] = "B"
but you can have
[Col] <> "A" and [COl] <> "B" means not([col] in {"A", "B"} )
2 Replies
Anonymous And is fine with not in.
For same value or is like in. [Col] ="A" or [COl] = "B" means [col] in {"A", "B"}
but you can not have
[Col] ="A" and [COl] = "B"
but you can have
[Col] <> "A" and [COl] <> "B" means not([col] in {"A", "B"} )