ISBLANK function
ISBLANK returns TRUE if a cell is truly empty and FALSE otherwise. A cell containing empty text or a single space is not blank, so it returns FALSE.
Example
Read it as a sentence: check whether F1 is completely empty, which gives TRUE.
Excel shows TRUE
F
1
Data
Syntax
ISBLANK(value)
-
value(required) - The cell or value to check.
Returns: TRUE if the cell is truly empty.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=ISBLANK("") | FALSE | Empty text literal |
=ISBLANK(0) | FALSE | Zero |
=ISBLANK(Data!F1) | TRUE | Blank cell |
=ISBLANK(Data!F8) | FALSE | Formula "" |
=ISBLANK(Data!F7) | FALSE | Cell with 0 |
=ISBLANK(Data!F1:F3) | TRUE | Range spills |
=ISBLANK(Data!E1) | TRUE | Column E blank |
The Data sheet these formulas read
A cell that starts with = holds that formula.
E
F
1
2
'123
3
2024-02-29
4
TRUE
5
=1/0
6
Hello World
7
0
8
=""
Data
Watch out for
- A cell containing "" or a space is not blank.
- Use LEN(cell)=0 to treat empty text as blank.
Where it works
- Excel
- ISBLANK is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Information functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .