Advanced Filters - using 'not contains' and 'is not' filters

Question

Hello,

I have TWO filters that include 'not contains' and 'is not' and want to make sure neither value appears in my smart list.

Most of the members won't have both but I want to make sure that if they have one, they are excluded.

Should I use (4 and 5) instead of (4 or 5)?

Attached is a screenshot. Filters 4 and 5 are the ones in question.

SanfordWhiteman · Accepted Answer

It's everyday Boolean logic. We use it implicitly in real life, too.

Let's say I'm going to the grocery store and someone says "get me some produce that's not a vegetable and not orange".

Section IS Produce AND ((Type IS NOT Vegetable) AND (Color IS NOT Orange))

SanfordWhiteman · Answer

Should I use (4 and 5) instead of (4 or 5)? Yes.

Sign up