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.

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)

Related Posts

• Automated interpolation formula for Excel: Define excel interpolate function & use it forever
• Delete Blank Rows in Ms Excel: Step-by-step Guide
• Evaluates String as if it Were a Formula in Excel
• How to Remove Duplicate Values in MS Excel
• How to convert columns into CSV using 1 simple Ms Excel function
• How to enable fill handle/formula drag-and-drop handle in Ms Excel
• How to make a macro available in all workbooks
• How to sort columns in Excel

C P Gupta

C P Gupta is a YouTuber and Blogger. He is expert in Microsoft Word, Excel and PowerPoint. His YouTube channel @pickupbrain is very popular and has crossed 9.9 Million Views.