How do I use ISBLANK in Excel?
Use ISBLANK when you want to check whether a cell is blank. Enter Value in that order, then add optional arguments when needed.
Excel Function
ISBLANK
Checks whether value is blank.
ISBLANK(value)Arguments
value
RequiredSpecify a single cell reference.
Practice Preview
Use ISBLANK to return the result with these settings (Value: D2 (cell D2 (Result in column D))).
Example Table
| # | AValue 1 | BValue 2 | CValue 3 | DResult |
|---|---|---|---|---|
| 2 | 120 | Text | ||
| 3 | 98.5 | 100 | ||
| 4 | 0 | N/A | ||
| 5 | 45 | Test | ||
| 6 | ||||
| 7 | ||||
| 8 |
How to Use (Formula)
=ISBLANK(D2)Result
TRUE
Practice This Function
ISBLANK FAQ
Where can I practice ISBLANK?
Use the "Start Function Practice" button to jump straight into ISBLANK drills.
What arguments does ISBLANK use?
The main arguments are Value. Enter them in order.