Excel ISBLANK: Check If a Cell Is Empty

Formulas & functions · Updated November 22, 2026

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

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.