Spread Formula Reference
Formula Functions / Functions H to L / ISLOGICAL
In This Topic
    ISLOGICAL
    In This Topic

    This function tests whether a value, an expression, or contents of a referenced cell is a logical (Boolean) value.

    Syntax

    ISLOGICAL(cellreference)

    ISLOGICAL(value)

    ISLOGICAL(expression)

    Arguments

    Specify a cell reference, a numeric or text value, or an expression for the argument.

    Remarks

    This function returns FALSE if the value refers to an empty cell or to no data.

    Use this function to test the contents of a cell, a numeric or text value directly, or a function or expression.

    Data Types

    Accepts any data type for an argument. Returns Boolean (TRUE or FALSE) data.

    Examples

    ISLOGICAL(B7)

    ISLOGICAL(R4C8)

    ISLOGICAL(true) gives a result TRUE

    ISLOGICAL(OR(B7,B8)) gives a result TRUE

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    ISNONTEXT | ISNUMBER | ISTEXT | Information Functions