excel return blank if cell is empty code example
Example 1: excel check if cell not empty
IF(A1<>"","Not empty","Empty")
Example 2: excel return 1 if cell looks blank
'Excel formula, returns 1 if cell looks blank and 0 otherwise:
=--(A1="")
IF(A1<>"","Not empty","Empty")
'Excel formula, returns 1 if cell looks blank and 0 otherwise:
=--(A1="")