close
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!
There are a number of ways, one of which is you can wrap your formula in an
IF statement......
=IF(YourFormula=0,quot;quot;,YourFormula)
Vaya con Dios,
Chuck, CABGx3quot;lehighgrantquot; gt; wrote in message
...
gt; Is there a way to get rid of the default zero that pops up when you enter
a
gt; formula but there is no information inputted into that cell yet?
gt; Thank you!
全站熱搜