How to use Excel ISBLANK Function


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.




  • 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.


  • 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.


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.

Leave a Comment

Your email address will not be published. Required fields are marked *