XL: How to Create a Formula to Correctly Evaluate Blank Cells

Microsoft Excel interprets a blank cell as zero, and not as empty or blank. ... formula returns "zero" if there is a zero value in the cell, "blank" if the cell is blank, and "other" if anything else is in the cell.

support.microsoft.com