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.


= AND(logical1, [logical2], …)


- Logical1 is required, the first argument to meet.

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


- 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