View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default 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!