How to Use AND Function

The AND function returns true when all the arguments are met, and returns false when one or more arguments are not met.

Formula:

= AND(logical1, [logical2], …)

Explanations:

– Logical1 is required, the first argument to meet.

– Logical2 is optional, the second argument to meet, up to a maximum of 255 conditions.

Cautions:

– When the argument contains text or empty cells, they are ignored.

– The AND function returns the #VALUE! error when there is no logical value in the specified range.

Download: AND Function

Leave a Reply