Filter and contains

[Mario36]

 

Hi All,

I am looking to find the restaurants in Bangalore where the dishes 'Kebab' or 'Chilly Chicken' are available. I have used the below formula on the Custom Filter tool but it does give me restaurant names apart from Bangalore too. Grateful if anyone could help. The excel file and screenshot is attached.

[Location] = "Bangalore" AND
Contains([Chicken Dishes],"Kebab") OR Contains([Chicken Dishes],"Chilly chicken")

[atcodedog05 · Accepted solution]

Hi @Mario36 

If you can formula like below it should work.

[Location] = "Bangalore" AND
(Contains([Chicken Dishes],"Kebab") OR Contains([Chicken Dishes],"Chilly chicken"))

I am warping up the or condition with brackets.

Hope this helps 🙂

[Mario36]

Sweet. This helps. Never knew this was so simple to use brackets and group my formula similar to excel. Thanks @atcodedog05