how do you get rid of default 0 in a cell that has a formula set u
 

Is there a way to get rid of the default zero that pops up when you enter a
formula but there is no information inputted into that cell yet?
Thank you!

how do you get rid of default 0 in a cell that has a formula set u
 

There are a number of ways, one of which is you can wrap your formula in an
IF statement......

=IF(YourFormula=0,"",YourFormula)

Vaya con Dios,
Chuck, CABGx3


"lehighgrant" wrote in message
...
Is there a way to get rid of the default zero that pops up when you enter
a
formula but there is no information inputted into that cell yet?
Thank you!