Excel ISBLANK Function

Excel ISBLANK Function


Test if a cell is empty

Return value 

A logical value (TRUE or FALSE)


=ISBLANK (value)


  • value – The value to check.

Usage notes 

Use the ISBLANK function to see if a cell is empty or not.

For example, =ISBLANK(A1) will return TRUE if A1 is empty, and FALSE if A1 contains text or formulas.

It’s probably best to think of ISBLANK as meaning “is empty” since it can return true when cells look blank but aren’t.

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas