Documentation/Calc Functions/ISLOGICAL

    From The Document Foundation Wiki
    Other languages:


    Function name:

    ISLOGICAL

    Category:

    Information

    Summary:

    Determines whether the supplied argument results in a logical value (TRUE or FALSE).

    Syntax:

    ISLOGICAL(Value)

    Returns:

    Returns TRUE if the argument evaluates to a logical value and FALSE otherwise.

    Arguments:

    Value is an expression, or a reference to a cell containing an expression, that is to be tested to determine if it evaluates to a logical value.

    Additional details:

    • Although a logical value in Calc is simply a number with a Boolean format, ISLOGICAL returns FALSE if the supplied argument evaluates to any number.
    • ISLOGICAL does not propagate errors. For example, if cell F1 contains the formula =1/0 and thus displays the #DIV/0! error, then =ISLOGICAL(F1) returns FALSE rather than the error. Similarly =ISLOGICAL(SQRT(-2)) returns FALSE rather than an error.

    Examples:

    Formula Description Returns
    =ISLOGICAL(99) Here the function returns FALSE because 99 is a number, not a logical value. The value of the number is not significant - for example the formulas =ISLOGICAL(0) and =ISLOGICAL(1) both return FALSE. FALSE
    =ISLOGICAL(D1) where cell D1 contains the value FALSE. Here the function returns the logical value TRUE because cell D1 contains a logical value – which logical value is not important. TRUE
    =ISLOGICAL(ISNA(D4)) Here the function returns the logical value TRUE whatever the contents of cell D4, because the ISNA function returns a logical value. TRUE

    Related LibreOffice functions:

    ISTEXT

    ISNUMBER

    ODF standard:

    Section 6.13.19, part 2

    Related (or similar) Excel functions:

    ISLOGICAL