ExcelHeroThe ISBLANK function
Checks whether a cell is empty.
In German Excel: ISTLEER
How to write it
=ISBLANK(value)- value
- The cell to check.
💡 A cell with a formula that returns "" is not blank.
Try it
Did Tom leave the email empty?
A
B
C
D
1
Name
Email
Plan
No email?
2
Lena
Pro
3
Tom
Free
4
Ivy
Free
5
Max
Pro
6
Zoe
Free
=ISBLANK(cell) is TRUE when there is nothing in it.