Hi
you may post your formula:
To identify a blank cell use
=IF(ISBLANK(A1),"something","something else")

For checking for zeros use
=IF(A1=0,"something","something else")

For blank cells as well as the formula result "" use
=IF(A1="","something","something else")

--
Regards
Frank Kabel
Frankfurt, Germany

"Slider" schrieb im Newsbeitrag
...
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