AND
Returns TRUE if all of its arguments are TRUE
Syntax
AND(logical1, [logical2], ...)
Parameters
- logical1: Required. The first condition to evaluate to TRUE or FALSE
- logical2: Optional. Additional conditions, up to 255
Example
=AND(A1>0, B1<100)
Returns TRUE if all of its arguments are TRUE
AND(logical1, [logical2], ...)
=AND(A1>0, B1<100)