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: B6)), "", SUM (B2: B6))
In this case, we use ISBLANK in combination with the OR function, so the logical test is TRUE if there is at least one blank cell in the range. Consequently, the SUM function goes to the value_if_false argument. Excel formula: count if cell is not blank
As you probably know, Excel has a special function to count non-empty cells, the COUNTA function. Please be aware that the function counts cells containing any type of data, including the logical values of TRUE and FALSE, error, spaces, empty strings, etc. Fo