Jump to content

Documentation/Calc Functions/ISBLANK

From The Document Foundation Wiki


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