Contact
12 programs
Explore the site

ISBLANK Function (LibreOffice Calc)

Information Beginner LibreOffice Calc Introduction not established

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.

Verification status: Consult the documentation, examples and any stated test scope below. How formula examples are checked

Availability and version history

  • Introduced: Documented by LibreOffice 26.8.1.1; original introduction not established.
  • Availability: Supported in LibreOffice 26.8.1.1, verified against its function registry. This identifies a supported release, not a final working version.
  • Scope: Desktop Calc, using the English function name. Availability in other spreadsheet applications is separate.
  • Checked: 2026-10-14 — function reference; versioned support. Documentation/source check; not a new native test. Existing example-specific test claims below retain their stated scope.
The **ISBLANK** function checks whether a cell is truly empty in LibreOffice Calc. It is essential for data validation, conditional logic, cleaning datasets, and building robust spreadsheet workflows. ISBLANK is often used with `IF`, `LEN`, and `TRIM` to detect missing or placeholder data.

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
ISBLANK is perfect for detecting truly empty cells — but remember that formulas returning "" are not considered blank.
  • 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.

Reproducible example (tested in LibreOffice Calc)

This standalone example was calculated in LibreOffice Calc 25.2.3.2 and matched the expected value. It is a practical cross-check of one usage, not proof that every example elsewhere on this page is correct.

Leave A9:A11 empty in the practice sheet when trying this example.

=ISBLANK(A10)

Expected result: TRUE.

Check whether a sample cell is empty.

If the result differs, check the referenced cells, argument separators and number formatting. For more information, consult the LibreOffice Calc official help.