Forum Discussion
AND with 3 filters
Hi,
I need to use 3 filters in my IF function. I am able to use AND function but that allows only 2 filters.
Any ideas for 3 or more filters?
nest the AND, or use && notation
AND(Filter 1, AND(Filter 2, Filter 3) )
or
Filter 1 && Filter 2 && Filter 3
Hope this helps
David
2 Replies
- dedelman_clng
Community Champion
nest the AND, or use && notation
AND(Filter 1, AND(Filter 2, Filter 3) )
or
Filter 1 && Filter 2 && Filter 3
Hope this helps
David