ISBLANK

Check if a cell is blank in Excel
Returns TRUE if the value is blank

Rational

Check if a cell is blank

Description

The Excel ISBLANK function check if a specified cell is blank (empty) and returns “TRUE” when a cell is blank, and “FALSE” when a cell is not blank. For example: “=ISBLANK(“Text”)” return FALSE as the cell contain some value “Text”.

Syntax

=ISBLANK(value)

Parameters

value – Refer cell to check if empty

Return Value

A Boolean value (TRUE or FALSE)

Key Notes

  • The ISBLANK formula cell is useful in finding a blank cell within a large data set.
  • Even space “ ” which is visibly blank is considered as a value, resulting ISBLANK function to return “FALSE” result.
  • The ISBLANK formula is part of IS functions that return either TRUE or FALSE, depending on the argument they’re evaluating.

Keep Reading Similar Functions:

Check a cell for valid reference in Excel

ISREF

The ISREF function checks if a cell has a correct reference, returns “TRUE” when a cell has a valid reference, and “FALSE” for reference error or not linked.

Read More »

ISFORMULA

The ISFORMULA function check if a specified cell is containing a formula and returns “TRUE” if it contains, I.e., cell C6 =2+2, “=ISFORMULA(C6)” returns TRUE.

Read More »
Check if cell returns a logical value in Excel

ISLOGICAL

The ISLOGICAL function check if a specified cell has Boolean value and returns “TRUE” when a cell has a Boolean data type, and “FALSE” if it does not.

Read More »