ISBLANK
Returns TRUE if a cell is empty.
How it’s written
ISBLANK(cell)Example
| A | B | |
|---|---|---|
| 1 | Name | Filed |
| 2 | Amara | Yes |
=ISBLANK(B2)Result: FALSE
B2 contains Yes, so it isn’t blank.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
A cell with a space in it isn’t blank, which catches many people out.
Practice it properly
Handling errors and gaps gives you real tasks, with your formulas tested on data you haven’t seen.