Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to check if a cell is blank with IF in Excel and Google Sheets
Topic:IF, IFS & nested conditionsExcel & Google Sheets
=IF(ISBLANK(A2),"Empty","Has Value")✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Value | Result |
| Hello | |
| 42 | |
=IF(ISBLANK(A2),"Empty","Has Value")→Has Value
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1To check if A2 is blank, use =IF(ISBLANK(A2),"Empty","Has Value"). ISBLANK returns TRUE only for truly empty cells.
- 2Alternatively, use the empty string comparison: =IF(A2="","Empty","Has Value"). This also catches cells that contain a zero-length string.
- 3Combine with other logic to skip calculations: =IF(ISBLANK(A2),"",A2*B2) returns blank instead of an error when A2 is empty.
Tips
- ISBLANK is stricter than A2="". ISBLANK returns FALSE for cells with a zero-length string (""), while A2="" returns TRUE for them. Choose based on your data.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
What is the difference between ISBLANK and checking A2=""?
ISBLANK is TRUE only for a cell with no content whatsoever. A2="" is also TRUE for cells that contain an empty string formula result.
How do I count blank cells in a range?
Use COUNTBLANK(range) to count cells that are empty or contain empty strings, or SUMPRODUCT(--(range="")) for more control.
More on IF, IFS & nested conditions
See all →How-to
How to hide #N/A and other formula errors
Replace #N/A, #DIV/0!, and other errors with a blank or a friendly message using IFERROR or IFNA. Works in Excel and Google Sheets.
Error fixFix Nested IF
Nested IF formulas not working in Excel and Google Sheets — fix bracket mismatches, wrong evaluation order, overlapping conditions, and the 64-nesting limit.
How-toHow to return a value if a cell contains text
Check if a cell contains specific text with IF + ISNUMBER + SEARCH and return any value you want — plus case-sensitive checks, multiple keywords, and wildcard alternatives.
How-toHow to return blank instead of zero
Stop formulas showing 0: wrap them in IF to return an empty string, suppress zeros with a custom number format, or hide them sheet-wide — plus the VLOOKUP-returns-0 fix.
How-toHow to sum if a cell contains specific text
Use SUMIF with wildcard criteria (*text*) to sum values in a column whenever a related column contains a specific substring.
How-toHow to write a nested IF formula
Chain multiple IF functions inside each other to test several conditions and return different results for each scenario.