ISBLANK Function (LibreOffice Calc)
The ISBLANK function in LibreOffice Calc checks whether a cell is truly empty. It is essential for data validation, conditional logic, cleaning datasets, and building robust spreadsheet workflows.
Compatibility
▾| Excel | ✔ |
| Gnumeric | ✔ |
| Google_sheets | ✔ |
| Libreoffice | ✔ |
| Numbers | ✔ |
| Onlyoffice | ✔ |
| Openoffice | ✔ |
| Wps | ✔ |
| Zoho | ✔ |
What the ISBLANK Function Does ▾
- Returns TRUE if a cell is completely empty
- Returns FALSE if the cell contains text, numbers, formulas, spaces, or errors
- Useful for data cleaning and conditional logic
- Works with direct references only
It is designed to be simple, reliable, and universally compatible.
Syntax ▾
ISBLANK(value)
Arguments
- value:
A cell reference to test.
Basic Examples ▾
Check if A1 is empty
=ISBLANK(A1)
Use with IF to fill missing data
=IF(ISBLANK(A1); "Missing"; A1)
Check if a referenced cell is empty
=ISBLANK(B2)
Check if a formula cell is blank
=ISBLANK(A1)
Returns FALSE if A1 contains a formula, even if the formula returns “”.
Advanced Examples ▾
Detect visually empty cells that contain formulas
=A1 = ""
TRUE if the formula result is an empty string.
Detect cells that contain only spaces
=LEN(TRIM(A1)) = 0
Useful for cleaning imported data.
Check if a range contains any blank cells
=COUNTBLANK(A1:A10) > 0
Check if a cell is blank OR contains an empty string
=OR(ISBLANK(A1); A1 = "")
Validate required fields
=IF(ISBLANK(A1); "Error: Required"; "OK")
Conditional formatting: highlight blank cells
ISBLANK(A1)
Used as a condition in formatting rules.
Check if a cell is blank before performing a calculation
=IF(ISBLANK(A1); ""; A1 * 2)
Prevents errors in dependent formulas.
Edge Cases and Behavior Details ▾
A cell with a formula is NOT blank
=ISBLANK(A1)
Returns FALSE if A1 contains any formula, even if the formula returns “”.
A cell containing a space is NOT blank
=ISBLANK(" ")
Returns FALSE.
A cell containing "" is NOT blank
=ISBLANK("")
Returns FALSE.
A cell containing an error is NOT blank
=ISBLANK(#N/A)
Returns FALSE.
A cell containing a number formatted to look empty is NOT blank
=ISBLANK(A1)
Returns FALSE even if formatting hides the value.
Common Errors and Fixes ▾
ISBLANK returns FALSE unexpectedly
Cause:
- Cell contains a formula
- Cell contains spaces
- Cell contains an empty string ""
- Cell contains hidden characters
Fix:
Use TRIM, CLEAN, or LEN to detect pseudo-empty cells.
ISBLANK returns TRUE unexpectedly
Cause:
- Referencing a cell that is truly empty
- Using ISBLANK on a reference that resolves to an empty cell
ISBLANK used on a literal value
=ISBLANK("")
Returns FALSE because "" is not a blank cell.
Best Practices ▾
- Use ISBLANK for detecting truly empty cells
- Use A1 = "" to detect formula‑generated empty strings
- Use LEN(TRIM(A1)) = 0 to detect whitespace-only cells
- Use COUNTBLANK for ranges
- Use ISBLANK inside IF for clean conditional logic
Related Patterns and Alternatives ▾
- Use A1 = “” to detect empty-string formulas
- Use LEN(TRIM(A1)) = 0 to detect whitespace-only cells
- Use COUNTBLANK to count blank cells in a range
- Use ISNUMBER, ISTEXT, ISLOGICAL for type checking
- Use IF to build conditional workflows
By mastering ISBLANK and its companion functions, you can build clean, reliable, and error‑resistant data workflows in LibreOffice Calc.