Spread Formula Reference
Formula Functions / Functions A to C / AND
In This Topic
    AND
    In This Topic

    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