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.
