Excel Formula for Checking if Cell Is Blank

Formulas & functions · Updated November 22, 2026

The simplest Excel formula for checking if a cell is blank 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 more flexible checks, you can combine ISBLANK with IF to display custom messages, or use COUNTBLANK to count blank cells in a range.

Why Checking for Blanks Matters

Blank cells are a common source of errors in spreadsheets. A formula like =A1+B1 treats a blank cell as 0, which may be fine for arithmetic but wrong for text or dates. Checking for blanks helps you validate data entry, avoid mistakes in calculations, and build dashboards that show meaningful status messages. For example, you might want to display “Pending” when a cell is empty, or highlight incomplete rows in a report.

The ISBLANK Function: Syntax and Behavior

The ISBLANK function takes exactly one argument: a cell reference or a range. It returns TRUE if the cell is truly empty—no value, no formula, no space characters. If a cell contains a formula that returns "" (an empty string), ISBLANK returns FALSE because the cell technically contains a formula. This is a common gotcha.

For example, with cell A1 completely empty, =ISBLANK(A1) returns TRUE. If A1 contains the formula =IF(1=2,"","x"), it returns FALSE even though the displayed value might look blank.

Using IF with ISBLANK for Custom Output

To return a custom message instead of TRUE/FALSE, wrap ISBLANK in an IF function. The syntax is =IF(ISBLANK(A1),"Blank","Not Blank"). With A1 empty, this returns “Blank”; with any content, it returns “Not Blank”.

For a more practical example, suppose you have a list of order dates in column A (A2:A100) and you want to mark overdue orders that haven’t been shipped (column B contains ship dates). In cell C2, use =IF(ISBLANK(B2),"Overdue","Shipped") and drag down. This checks if the ship date is missing and labels the row accordingly.

Alternatives: COUNTBLANK and Other Functions

If you need to count how many cells in a range are blank, use =COUNTBLANK(A1:A10). This returns the number of empty cells in that range. It counts cells that are truly empty, but also counts cells with formulas that return "" (empty text) because those are considered blank by COUNTBLANK.

Another alternative is the IF function with a direct comparison: =IF(A1="","Blank","Not Blank"). This checks if the cell equals an empty string. This works for truly empty cells and for cells with formulas returning "", but it will treat a cell containing a single space as “Not Blank” because a space is not an empty string.

Common Problems and Misconceptions

One frequent issue is that a cell looks blank but is not. This can happen if the cell contains a space character, a line break, or a formula that returns "". To identify such cells, use =LEN(A1)=0 which returns TRUE only if the cell has zero characters. This is more reliable than ISBLANK for detecting visually empty cells.

Another misconception is that ISBLANK works on a range. It does not—it only evaluates a single cell. To check if any cell in a range is blank, use =COUNTBLANK(A1:A10)>0 or an array formula like =SUMPRODUCT(--ISBLANK(A1:A10))>0.

Also note that ISBLANK is not the same as ISEMPTY (which does not exist in Excel). Some users confuse it with ISNUMBER or ISTEXT—those check data type, not emptiness.

Conditional Formatting to Highlight Blanks

You can use ISBLANK in conditional formatting to visually flag blank cells. Select the range, go to Home > Conditional Formatting > New Rule, choose “Use a formula to determine which cells to format”, and enter =ISBLANK(A1) (adjusting A1 to the top-left cell of your selection). Set a fill color and click OK. This will highlight all truly blank cells in the selected range.

If you want to highlight cells that are visually empty (including those with "" formulas), use =LEN(A1)=0 instead. Remember that conditional formatting formulas are relative to the active cell in the selection, so always reference the first cell.

Frequently Asked Questions

Q: Why does ISBLANK return FALSE when the cell appears empty?
A: The cell likely contains a formula that returns an empty string, a space, or a non-printing character. Use =LEN(A1)=0 to check for zero-length text, or press Ctrl+H to find and replace spaces.

Q: Can I use ISBLANK with a range like ISBLANK(A1:A10)?
A: No, ISBLANK only accepts a single cell reference. To check if any cell in a range is blank, use =COUNTBLANK(A1:A10)>0 or an array formula such as =SUMPRODUCT(--ISBLANK(A1:A10))>0.

Q: How do I count blank cells in a column?
A: Use =COUNTBLANK(A:A) to count all blank cells in column A. This counts cells that are truly empty and cells with formulas returning "", but not cells with spaces.

Q: What is the difference between ISBLANK and IF(A1=””,…)?
A: ISBLANK returns TRUE only for truly empty cells. The comparison A1="" returns TRUE for empty cells and for cells with formulas that return an empty string, but FALSE for cells with a space character.

Q: Can I use ISBLANK in data validation to prevent blank entries?
A: Yes, but it’s easier to use the built-in “Ignore blank” option. For a custom rule, select the cell, go to Data > Data Validation, choose Custom, and enter =NOT(ISBLANK(A1)) to require a value.

Q: Does ISBLANK work the same in Google Sheets?
A: Yes, the function name and behavior are identical. However, in Google Sheets, you can also use =ISBLANK(A1) and it works the same way.

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.