Advanced Filtering, When to use AND/ OR?

[Anonymous]

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 

[amitchandak · Accepted solution]

@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"} )

[Anonymous]

Ah that makes sense.. thanks!