Title: ISBLANK function in Excel to check if cell is blank
Headings: Excel ISBLANK function to check if cell is empty or not
Excel ISBLANK function to check if cell is empty or not
Excel ISBLANK function
ISBLANK (value)
=ISBLANK (A2)
=NOT (ISBLANK (A2))
ISBLANK in Excel - things to remember
How to use ISBLANK in Excel
Excel formula: if cell is blank then
=IF (ISBLANK (B2), "Open", "Completed")
=IF (Sheet3!B2<>"",Sheet3!B2,"")
=IF (B2="", "Open", "Completed")
Excel formula: if cell is not blank then
=IF (NOT (ISBLANK (B2)), "Completed", "")
=IF (ISBLANK (B2), "", "Completed")
=IF (B2<>"", "Completed", "")
If cell is blank, then leave blank
=IF (ISBLANK (B2), "", B2*10%)
=IF (B2="", "", B2*10%)
If any cell in range is blank, then do something
COUNTBLANK (range)>0
SUMPRODUCT (-- (range=""))>0
=IF (COUNTBLANK (B2:D2)>0,"Open", "")
=IF (COUNTIF (B2:D2,"")>0, "Open", "")
=IF (SUMPRODUCT (-- (B2:D2=""))>0, "Open", "")
If all cells in range are blank, then do something
=IF (COUNTA (B2:D2)>0, "", "Not Started")
=IF (COUNTIF (B2:D2,"<>")>0, "", "Not Started")
=IF (SUMPRODUCT (-- (B2:D2<>""))>0, "", "Not Started")
=IF (AND (ISBLANK (B2:D2)), "Not Started", "")
Excel formula: if cell is not blank, then sum
If not blank then sum
=SUMIF (B2:B6, "<>", C2:C6)
If blank then sum
=SUMIF (B2:B6, "", C2:C6)
Sum if all cells in range are not blank
=IF (COUNTBLANK (B2:B6)=0, SUM (B2:B6), "")
=IF (OR (ISBLANK (B2:B6)), "", SUM (B2:B6))
Excel formula: count if cell is not blank
=COUNTA (B2:B6)
=COUNTIF (B2:B6,"<>")
=COUNTBLANK (B2:B6)
Excel ISBLANK not working
Treat zero-length strings as blanks
=IF (A2="", "blank", "not blank")
=IF (LEN (A2)=0, "blank", "not blank")
Remove or ignore extra spaces
=IF (OR (A2="", LEN (TRIM (A2))=0), "blank", "not blank")
=IF (OR (A2="", A2=CHAR (160)), "blank", "not blank")
Available downloads
You may also be interested in

Content: This behavior occurs if a cell contains any of the following: Formula that returns an empty string like IF (A1<>"", A1, ""). Zero-length string imported from an external database or resulted from a copy/paste operation. Spaces, apostrophes, non-breaking spaces ( ), linefeed or other non-printing characters. How to use ISBLANK in Excel
To gain more understanding of what the ISBLANK function is capable of, let's take a look at some practical examples. Excel formula: if cell is blank then
Since Microsoft Excel does not have a built-in IFBLANK kind of function, you need to use IF and ISBLANK together to test a cell and perform an action if the cell is empty. Here's the generic version: IF (ISBLANK ( cell ), " if blank ", " if not blank ")
To see it in action, let's check if a cell in column B (delivery date) has any value in it. If the cell is blank, then output "Open";