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!

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()