Introduction:-                

ISBLANK function in excel is an information function. It is used to find out whether cells are empty. It returns TRUE if cell is empty otherwise returns FALSE. It is a worksheet function and can be entered in the cell in which value is required.

Syntax:-

=ISBLANK(VALUE)

Arguments:-

• Value:  It is the value which will be tested. It can be in form of an empty cell, an error, number, text, logical value etc.

Keynotes:-

• Values of the arguments in ISBLANK function are not converted.
• This function can be used with functions like IF function, testing outcomes, locating errors etc.

Examples

In this example, various example values are entered in column B with some of them left blank, and ISBLANK function is used to find out which of them are blank and which of them are not.