Excel Formula for Checking If a Cell Is Empty

Formulas & functions · Updated November 22, 2026

The simplest Excel formula for checking if a cell is empty is =ISBLANK(A1), which returns TRUE if A1 is empty and FALSE if it contains any value, including a formula that returns an empty string. For a more flexible check that treats formulas returning “” as empty, use =A1="" or =COUNTBLANK(A1)>0.

Why You Need to Check for Empty Cells

Empty cells are a common source of errors in spreadsheets. A formula like =A1+B1 treats blanks as zero, which can be fine for addition but misleading for averages or counts. Checking emptiness lets you:

  • Highlight missing entries in a data entry sheet.
  • Skip blank rows in calculations or reports.
  • Conditionally format cells that need attention.
  • Combine with IF to show custom messages like “Pending” or “N/A”.

Understanding the difference between a truly empty cell and a cell that looks empty (e.g., contains a space or a formula returning “”) is key to choosing the right formula.

How ISBLANK Works

ISBLANK is a built-in Excel function that checks whether a referenced cell is completely empty. It returns TRUE for a cell that has never been edited or has been cleared. It returns FALSE if the cell contains any value: a number, text, a date, a space, or even a formula that returns an empty string.

For example, with cell A1 empty, =ISBLANK(A1) returns TRUE. If A1 contains the formula ="", ISBLANK returns FALSE because the cell technically contains a formula. This is a common gotcha.

Syntax: =ISBLANK(value) – the value is usually a cell reference like A1.

Using IF with ISBLANK for Custom Outputs

The most practical use is nesting ISBLANK inside an IF function to return a custom result. For instance, with a list of order dates in A2:A100 and delivery dates in B2:B100, you can flag undelivered orders:

Assume data starts in row 2. In C2, enter:

=IF(ISBLANK(B2), "Not delivered", "Delivered")

This checks if B2 is empty. If true, it returns “Not delivered”; otherwise, “Delivered”. Drag down to fill the column. This works in Excel for Microsoft 365, Excel 2021, and older versions.

Counting Empty Cells with COUNTBLANK

If you need to know how many cells in a range are empty, use COUNTBLANK. For example, with survey responses in A1:A20, =COUNTBLANK(A1:A20) returns the number of blank cells. This is useful for quality checks or progress tracking.

Note: COUNTBLANK counts cells that contain formulas returning “” as blank, unlike ISBLANK. This makes it a better choice when you want to treat “invisible” results as empty.

Comparing ISBLANK, =””, and COUNTBLANK

Different methods treat blank-like cells differently. Here’s a quick comparison:

  • ISBLANK(A1) – TRUE only if A1 is truly empty. Returns FALSE for formulas returning “”.
  • A1=”” – TRUE if A1 is empty OR contains a formula that returns an empty string. Returns FALSE for a space character (” “).
  • COUNTBLANK(A1:A10) – Counts cells that are empty or contain formulas returning “”. Does not count cells with spaces.

For most cases, =A1="" is the most intuitive check because it treats a formula that yields nothing as empty. Use ISBLANK when you need to distinguish between a truly untouched cell and a formula output.

Common Problems and Solutions

One frequent issue is that a cell appears empty but ISBLANK returns FALSE. This often happens because the cell contains a space, a non-breaking space (CHAR(160)), or a formula returning “”. To identify the culprit, select the cell and look at the formula bar. If it shows a formula, that’s the cause. If it appears blank but has a space, use =TRIM(A1)="" to ignore spaces.

Another problem is using ISBLANK with a range. ISBLANK only works with a single cell; for a range, use COUNTBLANK or SUMPRODUCT. For example, to check if all cells in A1:A5 are empty, use =COUNTBLANK(A1:A5)=5.

Alternatives: Using IF with LEN and Other Functions

If you need to treat cells with only spaces as empty, combine IF with LEN and TRIM. For instance, =IF(LEN(TRIM(A1))=0, "Empty", "Not Empty") returns “Empty” for truly blank cells or cells with only spaces. This is more robust than ISBLANK for data imported from other systems.

For conditional formatting, you can use a formula rule like =ISBLANK(A1) to highlight blank cells. Select the range, go to Home > Conditional Formatting > New Rule > Use a formula, and enter the formula. This works in Excel for Microsoft 365, Excel 2021, and older versions.

Frequently Asked Questions

Why does ISBLANK return FALSE for a cell that looks empty?

Because the cell contains something invisible, like a space, an apostrophe, or a formula that returns an empty string. Check the formula bar to see what’s actually there. Use =A1="" to catch formula-returned blanks.

How do I check if a cell is not empty?

Use =NOT(ISBLANK(A1)) or simply =A1<>"". Both return TRUE if the cell has any content, including a space. For a stricter check that ignores spaces, use =LEN(TRIM(A1))>0.

Can I use ISBLANK in conditional formatting?

Yes. Select the range, go to Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format, and enter =ISBLANK(A1) (adjusting the reference to the top-left cell of the selection). Then set a format.

What is the difference between ISBLANK and COUNTBLANK?

ISBLANK checks a single cell and returns TRUE/FALSE. COUNTBLANK counts empty cells in a range and returns a number. COUNTBLANK treats cells with formulas returning “” as blank, while ISBLANK does not.

How do I check if a cell is empty in Google Sheets?

Google Sheets uses the same functions: =ISBLANK(A1) and =COUNTBLANK(A1:A10) work identically. The logic is the same as Excel.

Does ISBLANK work with merged cells?

ISBLANK only checks the top-left cell of a merged range. If you merge A1:B1 and leave it empty, ISBLANK(A1) returns TRUE, but ISBLANK(B1) returns FALSE because B1 is technically part of the merge but not the anchor cell.

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.