Many times while working with Excel formula, you need to know whether cell of excel is blank or empty. In this blog you will know different methods to check for blank or empty cell of Excel using formula
1: Using the ISBLANK() Function
Works with: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac and Excel 2016
ISBLANK function of excel returns TRUE when a cell is empty, and FALSE when a cell is not empty.
Syntax
=ISBLANK(Value)
e.g. ISBLANK(B5)
2: Using IF statement
Works with: All version of Excel
You can use traditional IF statement and check if the cell is empty.
Following formula check whether contents of Cell A2 is empty and returns True if empty or False if not empty.
Syntax
=IF(A2=””, True, False)