Hi Slider!

Try the following base:
=IF(ISBLANK(C18)=TRUE,"Blank",IF(C18="","Empty
String",IF(C18=0,"Zero","May be format hidden")))

If the only possibilities are Blank and 0 the formula can be edited to

=IF(ISBLANK(C18),"Blank","Zero")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Slider" wrote in message
...
Well the title says it all folks. I have a worksheet that
runs a formula that needs to be able to tell the
difference betwwen a blank cell and a cell value that
contains a zero. Presently the formula that displays the
blank cells as a zero as well as cells that contain zeros.
I need to find a solution that is able to differentiate
between the two.

Thanks in advance ....

Slider