Documentation/Calc Functions/ISBLANK

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.

Related LibreOffice functions:
ISNUMBER

ISTEXT

ODF standard:
Section 6.13.14, part 2

Equivalent Excel functions:
ISBLANK