The ISBLANK function
Returns TRUE when a cell is empty. A cell with a formula that returns "" is not empty.
Syntax
ISBLANK(value)- value
- The cell to check.
Examples
C1=ISBLANK(A5)
| A | B | C | |
|---|---|---|---|
| 1 | Units | TRUE | |
| 2 | 4 | ||
| 3 | n/a | ||
| 4 | 7 | ||
| 5 | |||
| 6 | 2 |
C1=ISBLANK(A3)
| A | B | C | |
|---|---|---|---|
| 1 | Units | FALSE | |
| 2 | 4 | ||
| 3 | n/a | ||
| 4 | 7 | ||
| 5 | |||
| 6 | 2 |