BeginnerLogic
Syntax
=ISBLANK(value)| Argument | What it means |
|---|---|
value | The cell to check. |
Examples with results
Every result below is calculated by the practice engine on the sample data shown, not typed in by hand.
List A and list B (fictional)
| Row | A | B |
|---|---|---|
| 1 | Ordered | Received |
| 2 | P-101 | P-102 |
| 3 | P-102 | P-101 |
| 4 | P-103 | P-105 |
| 5 | P-104 | P-103 |
| 6 | P-105 |
=ISBLANK(B6)Is the last Received cell empty?
=ISBLANK(B2)And the first?
Try it yourself
Change the formula or switch to other sample data.
Press Calculate to see the result.
The practice box runs in your browser with BDK’s own calculator, which covers about 60 common functions. Cell references work as in Excel (B2, B2:B9). Your formulas are not saved or sent anywhere. For anything unusual, check the result in Excel itself.
How people use ISBLANK at work
- Administration
Show a message only for missing items.
Data: List A and list B (fictional)=IF(ISBLANK(B6),"Not received","Received") - Operations
Check whether a reorder level was entered.
Data: Stock levels (fictional)=IF(ISBLANK(D2),"Set level","OK")
Common mistakes and tips
- A cell with a space or a formula returning "" is not blank to ISBLANK.
Works in
All versions of Excel, and Google Sheets.
Related formulas
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.