excel cell blank or zero

C
=IF(ISBLANK(B2),"blank",IF(B2=0,"zero","other"))

Source

Also in C: