How to Use the ISBLANK Function in Google Sheets
=ISBLANK(value). It is most often used inside IF.
What ISBLANK does
ISBLANK checks one cell and answers TRUE or FALSE. To count empty cells in a range, use COUNTBLANK. ISBLANK is for deciding what to do with a single cell, such as showing a warning when a required field is missing.
ISBLANK syntax
=ISBLANK(value)
The argument is a reference to the cell to check. It returns TRUE if the cell is empty and FALSE if it contains data. Google's help page adds an important caveat: a cell containing an empty string "", a space or a hidden character returns FALSE, because ISBLANK returns FALSE if the cell has any content at all. If you get an unexpected FALSE, clear the cell again to remove hidden characters.
A step-by-step example
Cell A2 holds a name and cell A3 is empty.
| A | |
|---|---|
| 1 | Name |
| 2 | Ann |
| 3 |
=ISBLANK(A3)
This returns TRUE, because A3 has nothing in it. =ISBLANK(A2) returns FALSE.
Use it inside IF
Pair it with IF to turn the result into words:
=IF(ISBLANK(A3), "Missing", "OK")
This returns Missing. Google's page shows a similar pattern, IF(ISBLANK(B1),,A1/B1), which skips a division when the divisor cell is empty.
Common mistakes
- Cells that look empty but are not. A space or
""makes ISBLANK return FALSE. - Checking a range. It checks one cell. Use COUNTBLANK for ranges.
- Mixing up TRUE and FALSE. TRUE means empty.
Try it yourself
Use the cells above (A2 and A3). Type your formula into the box, starting with =, then press Check.
Exercise 1: Is it empty?
Write a formula that returns TRUE if A3 is empty.
Exercise 2: Missing or OK
Write a formula that shows Missing if A3 is empty and OK if it is not.
What to learn next
- COUNTBLANK: count empty cells.
- IF: run a test and return one of two results.
- ISNUMBER: check whether a value is a number.
Syntax and rules in this guide were checked against Google's ISBLANK help page. See all guides.