The Excel ISBLANK function returns TRUE if a cell is completely empty and FALSE if it contains any value, including a formula that returns an empty string (“”). Use it as =ISBLANK(A1).
What ISBLANK Does
ISBLANK is one of Excel’s information functions. It takes exactly one argument—a cell reference or a value—and evaluates whether that cell is truly blank. A cell is blank only if it has never been edited and contains nothing at all. This includes cells that look empty but actually contain a formula returning "", a space character, or a zero-width non-breaking space. Those are not blank to Excel.
For example, if cell A1 is completely untouched, =ISBLANK(A1) returns TRUE. If A1 contains the number 0, the text “0”, a space, or a formula like =IF(1=2,"","x"), the function returns FALSE.
How to Use ISBLANK in a Formula
The syntax is simple:
=ISBLANK(value)
The value is usually a cell reference, but it can also be a direct value. For instance, =ISBLANK("") returns FALSE because the empty string is a value, not a blank cell.
You’ll often combine ISBLANK with other functions. For example, to display “Empty” when A1 is blank and “Has data” otherwise:
=IF(ISBLANK(A1),"Empty","Has data")
With A1 empty, this returns “Empty”. With A1 containing 5, it returns “Has data”.
You can also use it in conditional formatting to highlight blank cells. Select the range, go to Home > Conditional Formatting > New Rule > Use a formula, and enter =ISBLANK(A1) (adjusting the reference for the top-left cell of the selection).
ISBLANK vs. Counting Blank Cells
If you need to count how many cells in a range are blank, use COUNTBLANK instead of ISBLANK. For example, =COUNTBLANK(A1:A10) returns the number of empty cells in that range. Note that COUNTBLANK treats cells with formulas that return “” as blank, unlike ISBLANK which does not. This is a common source of confusion.
Common Problems and Misconceptions
A frequent issue: you expect ISBLANK to return TRUE for a cell that looks empty, but it returns FALSE. This usually happens because the cell contains a formula that returns an empty string, or an invisible character like a space. To check for these, select the cell and look at the formula bar. If it shows a formula, that’s the culprit. To fix it, either delete the formula or change it to return a true blank, which is not directly possible in Excel—you’d need to clear the cell entirely.
Another misconception is that ISBLANK works on a range. It does not. =ISBLANK(A1:A10) will return a single result based on the top-left cell, not an array. Use COUNTBLANK or an array formula (like =SUMPRODUCT(--ISBLANK(A1:A10))) to check multiple cells.
Alternatives to ISBLANK
Depending on what you need, other functions might be better:
- IF with ISBLANK – as shown above, for conditional output.
- COUNTBLANK – to count blanks in a range.
- LEN and TRIM – to detect cells that contain only spaces:
=IF(LEN(TRIM(A1))=0,"Blank or spaces","Has text"). - ISNUMBER, ISTEXT, ISLOGICAL – to check for specific data types.
- IFERROR with VLOOKUP – to handle missing lookups, though not directly a blank check.
For Excel 365 users, the LET function can make complex checks more readable, but ISBLANK remains the simplest direct test.
ISBLANK in Excel for Mac and Web
The function works identically in Excel for Microsoft 365 on Windows, Mac, and Excel for the web. The syntax and behavior are the same. The only difference is in keyboard shortcuts for entering formulas—on Mac, you press Cmd+Enter to confirm an array formula (though ISBLANK rarely needs array entry).
Practical Example: Checking for Missing Data
Suppose you have a list of orders in column A (order IDs) and delivery dates in column B. You want to flag orders that haven’t been delivered. With order IDs in A2:A100 and dates in B2:B100, put this in C2:
=IF(ISBLANK(B2),"Not delivered","Delivered")
Drag down to fill. This returns “Not delivered” for any row where B is empty, and “Delivered” otherwise. If a date is present but the cell contains a formula that returns “”, ISBLANK will incorrectly mark it as “Delivered”. To treat formula blanks as empty, use =IF(B2="","Not delivered","Delivered") instead.
Frequently Asked Questions
Why does ISBLANK return FALSE for a cell that looks empty?
Because the cell isn’t truly empty. It likely contains a formula that returns an empty string, a space, or a non-printing character. Check the formula bar to see what’s actually there.
Can ISBLANK check a range of cells at once?
No, ISBLANK only checks one cell. To count blanks in a range, use COUNTBLANK. To return an array of TRUE/FALSE for each cell, you’d need an array formula, but that’s rarely necessary.
What’s the difference between ISBLANK and COUNTBLANK?
ISBLANK returns TRUE/FALSE for a single cell. COUNTBLANK returns the number of blank cells in a range. Also, COUNTBLANK counts cells with formulas that return “” as blank, while ISBLANK does not.
How do I treat a formula that returns “” as blank?
Use a direct comparison: =IF(A1="",...) or =COUNTIF(A1,""). These treat empty strings as blank, unlike ISBLANK.
Is ISBLANK available in all Excel versions?
Yes, ISBLANK has been in Excel for decades and is available in all modern versions, including Excel for the web and mobile.
Related
- Excel Before Close Event: How to Run Code on Save
- SUBSTRING in Snowflake: Syntax, Examples, and Tips
- Excel Audit Process: Step-by-Step Guide
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel IF Greater Than: Formulas, Examples, and RulesIn Excel, use the greater-than operator > to test whether one number exceeds another; wrap the test in…
- Excel Date Plus 1 Month: Formula and Month-End RulesTo add one calendar month to a date in Excel, use the EDATE function: if the starting date…
- Excel Formula for Percentage of a NumberTo calculate a percentage of a number in Excel, multiply the number by the percentage: if A2 contains…
- Cost Savings Formula in Excel: Calculate and CompareTo calculate cost savings in Excel, subtract the new cost from the original cost: if the original amount…
- What-If Analysis in Excel: How It Works and When to Use ItWhat-If Analysis in Excel is a set of tools for seeing how changing input values affects a formula’s…
- Excel Set Print Area: How to Print the Right CellsTo set a print area in Microsoft Excel for Microsoft 365 on Windows, select the cells you want…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.