Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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:

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 »
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 »