Excel ISBLANK Function

The ‘ISBLANK’ formula in Excel is used to ascertain whether or not a specified input cell is blank (i.e. contains no characters at all) or not. It returns TRUE if the specified cell is empty, or FALSE if it is not. For example, =ISBLANK(“Contents”) would return FALSE.

Note that even if a cell contains a singular space character, the ISBLANK formula would return FALSE.

The ISBLANK function is part of a larger group of IS functions that all return logical values (i.e. TRUE or FALSE). The other IS functions are ISODD, ISEVEN, ISNUMBER and ISTEXT.

Syntax

=ISBLANK(value)

Arguments

Value – input cell to check. Note that only individual cells can be specified. If you select a cell range, the formula output will only refer to the upper left cell in the range.

Function category

Information

Returns

Returns a logical value i.e. TRUE if the specified cell is empty or FALSE if it is not.

Download Excel File

 Example of ISBLANK function

Comments (No)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.