Filter not working

[richleeb2]

I don't know why but the filter is not working.  I have a list of company names I want to filter out.  Using the filter tool, in the custom filter area, I put the following:

!Contains([Company Name],"McDonalds") or
!Contains([Company Name],"Burger King")

It's providing me with every record as True and zero records as false.  The company names are in the list under the column "Company Name"

What am I doing wrong?

[binu_acs]

@richleeb2 Use AND instead of OR in the filter condition 

Contains([Company Name],"McDonalds") AND
!Contains([Company Name],"Burger King")

[binu_acs · Accepted solution]

@richleeb2 

!Contains([Company Name],"McDonalds") AND
!Contains([Company Name],"Burger King")