Documentation/Calc Functions/ISBLANK

    From The Document Foundation Wiki
    Other languages:


    Function name:

    ISBLANK

    Category:

    Information

    Summary:

    Determines if a specified cell is empty.

    Syntax:

    ISBLANK(Value)

    Returns:

    Returns the logical value TRUE if the argument is a cell reference, and that cell is empty. Returns FALSE otherwise.

    Arguments:

    Value is a number, a logical value, a string, a date, or a cell reference.

    • If Value is a number, logical value, string, or date, then ISBLANK returns FALSE. If Value is a cell reference, then ISBLANK returns TRUE if the referenced cell is empty and FALSE otherwise.

    Additional details:

    • A cell that contains the empty string is not considered to be empty, even though it appears to be "blank".
    • ISBLANK does not propagate errors. If Value is a reference to a cell containing a formula that has resulted in an error, then ISBLANK returns FALSE.

    Examples:

    Formula Description Returns
    =ISBLANK(12.34) Here the function returns the logical value FALSE. FALSE
    =ISBLANK("Hello world!") Here the function returns the logical value FALSE. FALSE
    =ISBLANK(TRUE()) Here the function returns the logical value FALSE. FALSE
    =ISBLANK(2021-12-18) Here the function returns the logical value FALSE. FALSE
    =ISBLANK(D1) where cell D1 contains the formula =LEFT("Input string"; 0). Here the function in cell D1 returns the empty string and so ISBLANK returns the logical value FALSE. FALSE
    =ISBLANK(D2) where cell D2 contains no value or formula. Here cell D2 is empty and so ISBLANK returns the logical value TRUE. TRUE
    =ISBLANK(D3) where cell D3 contains the formula =1/0. Here the function in cell D3 generates a #DIV/0! error and so ISBLANK returns the logical value FALSE. FALSE

    Related LibreOffice functions:

    ISNUMBER

    ISTEXT

    ODF standard:

    Section 6.13.14, part 2

    Related (or similar) Excel functions:

    ISBLANK