Skip to content

How to check if excel cell is empty or blank

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.



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.


=IF(A2=””, True, False)

Related Posts

Leave a Reply

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