Syntax or pattern
Check whether a cell is blank before calculating or labeling it.
=ISBLANK(value)5 practical examples
Use ISBLANK to label overdue tasks
Create a simple status label based on a due date.
=IF(D2<TODAY(), "Overdue", "On track")Adjust the ranges, criteria and sheet names to match your workbook.
Use ISBLANK for pass/fail logic
Classify scores, targets, or quality checks.
=IF(B2>=70, "Pass", "Review")Adjust the ranges, criteria and sheet names to match your workbook.
Use ISBLANK for budget status
Compare actual spend to the planned amount.
=IF(C2>B2, "Over budget", "Within budget")Adjust the ranges, criteria and sheet names to match your workbook.
Use ISBLANK for blank checks
Flag missing values before reports are shared.
=IF(A2="", "Missing", "Complete")Adjust the ranges, criteria and sheet names to match your workbook.
Use ISBLANK for priority labels
Turn input values into clearer workflow labels.
=IF(E2="High", "Do first", "Normal")Adjust the ranges, criteria and sheet names to match your workbook.
Common mistakes to avoid
- Mixing text and numbers in comparisons.
- Forgetting quotation marks around text results.
- Creating nested formulas that are hard to audit.
FAQ
What is this Google Sheets page for?
This page gives copy-ready examples for isblank examples so you can understand the pattern and adapt it to real spreadsheet work.
Can I copy these formulas directly?
Yes. Use the copy buttons, then adjust sheet names, ranges, criteria and column references for your own file.
Why does my formula return an error?
The most common causes are mismatched ranges, missing quotes around text criteria, blank source data, or references that do not match your sheet layout.