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

L

lehighgrant

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!
 
C

CLR

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
 
Top