Summary
ISBLANK returns TRUE only when a cell is genuinely empty. If the cell contains anything at all, it returns FALSE.
That includes cases people often miss. A space is not blank. Zero is not blank. A formula that returns "" is also not blank, because the cell still contains a formula even though the screen looks empty.
Purpose
Returns TRUE only for cells with no content at all, which is useful for input checks and validation rules.
Return Value
TRUE means the cell is empty. FALSE means the cell contains something, even if it only looks blank.
Syntax
=ISBLANK(value)You usually pass a cell reference such as =ISBLANK(A1). Microsoft includes ISBLANK in the IS functions, which test the type or state of a value and return TRUE or FALSE.
Arguments
- value - [required] The cell or value you want to test.
ISBLANK vs Other Functions
| Function | Main job | Important difference |
|---|---|---|
ISBLANK |
Checks for true emptiness | A formula that returns "" still returns FALSE. |
ISTEXT |
Checks for text | Empty-looking text like "" counts as text there. |
ISNONTEXT |
Checks for anything that is not text | True blanks return TRUE there, but numbers do too. |
A1="" |
Checks whether the displayed result is empty text | Useful when you want to treat "" as empty-looking. |
Using ISBLANK
This function is most useful when you want to detect missing input. It works well in forms, validation rules, dashboards, and data-entry sheets where an untouched cell should trigger a warning, prompt, or follow-up action.
The biggest thing to remember is that ISBLANK is strict. It checks whether the cell is physically empty, not whether it only looks empty on screen. That makes it very helpful when you need to tell the difference between a user who has not entered anything yet and a formula that intentionally returns an empty-looking result.
That strictness is also why some people choose a direct comparison like A1="" instead. If your goal is to treat formula results that display as empty as blank enough, that comparison may fit better. If you need to know whether the cell truly contains nothing, ISBLANK is the clearer test.
Example 1 - Check a Blank Cell
This is the direct use of the function.
=ISBLANK(A1)If A1 is truly empty, the result is TRUE. If A1 contains any value, space, or formula, the result is FALSE. This makes it a clean first check for missing input.
In cell F1, check whether A1 is truly empty.
Example 2 - Prompt for a Missing Input
This is a practical way to make a form or worksheet easier to use.
=IF(ISBLANK(B2),"Mandatory Input","OK")If B2 is empty, the formula returns "Mandatory Input". Otherwise it returns "OK". This is useful when you want a workbook to guide the user toward unfinished fields instead of leaving them unnoticed.
In cell F2, show "Mandatory Input" if B2 is blank, otherwise show "OK".
Example 3 - Catch the Empty-String Trap
A formula can return an empty-looking result without making the cell truly blank.
=ISBLANK(C3)If C3 contains a formula that returns "", ISBLANK returns FALSE because the cell still contains a formula. This is one of the most important details to understand when using ISBLANK in real spreadsheets.
In cell F3, check whether C3 is truly blank even if it looks empty on screen.
Example 4 - Keep Zero Separate
Zero is still data, even if it can look like "nothing" in a summary.
=ISBLANK(0)This returns FALSE because 0 is a real numeric value, not an empty cell. That distinction matters when zero means an actual measured result and should not be mixed up with missing data.
In cell F4, confirm that 0 is not treated as a blank value.
Conclusion Recap
- Main job:
ISBLANKchecks for true emptiness. - Strict rule: Spaces, zero, and formulas all return FALSE.
- Useful for: Missing-input checks, forms, and validation prompts.
- Key nuance:
""can look blank but is not truly blank. - Alternative check: Use
A1=""when you want to treat empty-looking text as blank enough.
Tell your friends about this post