Documentation/Calc Functions/ISBLANK
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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:
ODF standard:
Related (or similar) Excel functions:
ISBLANK