How to tell the difference between a zero and a blank cell value

  • Thread starter Thread starter Slider
  • Start date Start date
S

Slider

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
 
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")
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top