Spread Formula Reference
AND
Formula Functions > Functions A to C > AND

This function calculates logical AND.

Syntax

AND(bool1,bool2,...)

AND(array)

AND(array1,array2,...)

AND(expression)

AND(expression1,expression2,...)

Arguments

For the arguments of this function, provide numeric (0 or 1) or logical values (TRUE or FALSE) for up to 255 arguments. You can also specify a single array instead of listing the values separately, or up to 255 arrays. You can also specify the logical argument as an expression.

Remarks

This function returns TRUE if all its arguments are true; otherwise, returns FALSE if at least one argument is false.

Data Types

Accepts logical data (Boolean values of TRUE or FALSE) or numerical values (0 or 1). Returns logical data (Boolean values of TRUE or FALSE).

Examples

AND(D12,E12)

AND(R12C42,R12C5,R12C1)

AND(D2:D12)

AND(R12C1:R12C9)

AND(true,true,true) gives the result TRUE

AND(TRUE(),FALSE()) gives the result FALSE

AND(5+3=8,5+1=6) gives the result TRUE

Version Available

This function is available in product version 1.0 or later.

See Also

NOT | OR | Logical Functions