AND

Name

And

Description

Returns 1 (True) if all its arguments are true; otherwise, returns 0 (False) if one or more arguments are false.

Syntax

AND(bool1, bool2, ...)

Remarks

Accepts up to 30 arguments. Provide numeric or logical values for the arguments.

See also FALSE, IF, NOT, OR, and TRUE.

Data Type

Accepts numeric (boolean) data. Returns numeric (boolean) data. For more information, see Data Type for Each Cell Type.

Example

AND(TRUE(), FALSE()) = 0 (False)
AND(5+3=8, 5+1=6) = 1 (True)