Navigation:  Formula Reference > Spreadsheet Formula Functions >

AND

Previous pageReturn to chapter overviewNext page

 

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

 

See Also

NOT

OR