AND with 3 filters

[Anonymous]

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?

[dedelman_clng · Accepted solution]

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

[Anonymous]

@dedelman_clng,

Thanks. That was easy.  Now I sound stupid!