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

[Shane_Rourke2]

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]

---

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

Yes.

[Shane_Rourke2]

Thanks, Sanford!

What's the reasoning? Is it because I am using negative filters? 

[SanfordWhiteman · Accepted solution]

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))

[Shane_Rourke2]

Sorry, last question. 

Should the logic go:

1 and 2 and 3 and 4 and 5

OR

1 and 2 and 3 and (4 and 5)? 

[SanfordWhiteman]

If they're all AND, there's no reason to parenthesize.

[SanfordWhiteman]

@Shane_Rourke2 please mark one of my answers as the Solution when you get a chance.