Quick Navigation

ISBLANK Function

Excel 2003+

Summary

The ISBLANK function determines if a cell is truly empty, returning TRUE for empty cells and FALSE for cells containing any content including formulas, spaces, or zero-length strings. It's essential for accurate data validation and conditional logic in spreadsheets.

Syntax

ISBLANK(value)

Parameters

Parameter	Type	Required	Description
value	`Any`	Yes	The cell reference or value to check if it's blank. Accepts references, numbers, text, errors, or logical values.

Using the ISBLANK Function

ISBLANK is perfect for data cleaning, validation rules, and conditional formulas. Use it to identify genuinely empty cells before processing data, preventing errors from cells that appear empty but contain formulas returning "" or have hidden spaces.

Common ISBLANK Examples

Basic Empty Cell Check

=ISBLANK(A1)

Returns TRUE if A1 contains no data or formula, FALSE otherwise.

Data Validation

=IF(ISBLANK(B2), "Required", "OK")

Displays 'Required' message for empty cells in B2.

Count Truly Empty Cells

=SUMPRODUCT(--ISBLANK(C1:C10))

Counts only truly empty cells in range (not those with formulas).

Prevent Processing Empty Cells

=IF(ISBLANK(D2), "", D2*100)

Only processes non-empty cells, returns blank for empty ones.

Frequently Asked Questions

No. ISBLANK returns FALSE for cells containing formulas, even if they display blank. It only detects truly empty cells.

ISBLANK tests a single cell/value. COUNTBLANK counts empty cells in a range.

No. Cells with spaces, even single spaces, return FALSE.

Common Errors and Solutions

ISBLANK returns FALSE for formula cells

Cause: Cell contains a formula even if result appears blank

Solution: Use LEN(TRIM(value))=0 to detect display-blank cells

Unexpected TRUE results

Cause: Cell is truly empty (no formula, no value)

Solution: This is correct behavior

Works incorrectly with arrays

Cause: Testing array formulas directly

Solution: Use with individual cell references

Notes

ISBLANK distinguishes truly empty cells from those with formulas returning ""
Does NOT treat cells with spaces, apostrophes, or zero-length strings as blank
Useful with IF statements for conditional processing
Combine with COUNTA/COUNTBLANK for comprehensive empty cell analysis
Performance efficient for large datasets

Compatibility

Available in: Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in:

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2003+