Excel ISBLANK: Check whether a cell is really empty

Excel’s ISBLANK returns TRUE only when the referenced cell contains nothing. A formula that returns an empty string can make a cell look empty while ISBLANK returns FALSE. Use ISBLANK to check for a cell with no entry, or compare with an empty string if both cases should pass.

Test one cell with ISBLANK

Enter the first formula in B2 to test A2. If A2 is empty, the result is TRUE. Changing the font color or number format leaves an empty cell empty. Add a number or a formula to A2 and the result changes to FALSE.

=ISBLANK(A2)

Microsoft’s documentation for ISBLANK

Compare an empty cell, empty text, a space, and zero

Prepare A2:A5 as shown in the table. Leave A2 empty and enter the formulas in A3 and A4, including the equals sign. The quotation marks in the A4 formula contain one space. Enter the number 0 in A5. Put the ISBLANK formula in B2 and the empty-string comparison in C2, then fill both down through row 5.

=A2=""
Cell What to enter =ISBLANK(A2) =A2=""
A2 Leave empty TRUE TRUE
A3 ="" (Formula returning empty text) FALSE TRUE
A4 =" " (Formula returning one space) FALSE FALSE
A5 0 FALSE FALSE

The tests differ at A3. Its formula returns text of length zero, so it equals an empty string, while the cell itself contains a formula. A4 returns text of length one, so both tests give FALSE there.

Hide the amount until the quantity is entered

Enter a quantity of 2 in A8 and a unit price of 300 in B8. Enter 0 in A9 and 200 in B9. Leave A10 empty and enter 200 in B10. Enter the formula below in C8 and fill down to C10. The results are 600, 0, and an empty string.

=IF(ISBLANK(A8),"",A8*B8)

C10 looks empty but contains a formula, so ISBLANK returns FALSE for it. If the quantity cell can itself contain a formula that returns empty text, use A8="" as the IF condition to treat that result as missing too. This condition does not validate spaces or other invalid text.

Microsoft’s guide to checking for blank cells with IF

What counts when you count blank cells

COUNTBLANK counts both empty cells and cells with formulas that return an empty string. In A2:A5, it counts A2 and A3 and returns 2. If you need to identify cells that have no entry, test each one with ISBLANK.

Microsoft’s documentation for COUNTBLANK