Goal: Determine if a cell is truly empty. ISBLANK returns TRUE only if the cell contains absolutely nothing.
TRUE
Ready...
💻 Formula Structure
=ISBLANK(value)
Value: The cell to check (e.g., A1).
Result: TRUE if empty. FALSE if it contains *anything* (even invisible text).
-- Check for emptiness
=ISBLANK( A1 )
Is it Blank?
-
⚠️ Common Pitfalls
🚫 Empty String ""
A formula returning "" (e.g. =IF(A1>10, "Yes", "")) makes the cell look blank, but ISBLANK will return FALSE because the cell contains a formula result.
👻 Invisible Spaces
Imported data often has trailing spaces. To a human, " " looks empty. To Excel, it's text. Always assume data is dirty until checked.