How do I make a cell appear empty when the formula = 0?

If the answer to the formula is 0, how can I make it just show the cell as
empty instead of actually putting a 0 in the cell?

=if(yourformulahere=0,"",yourformulahere)



t1202 wrote:
>
> If the answer to the formula is 0, how can I make it just show the cell as
> empty instead of actually putting a 0 in the cell?

--

Dave Peterson

In say A1
=IF(B1+B2=0,"",B1+B2)
Regards,
Alan
"t1202" <[email protected]> wrote in message
news:[email protected]...
> If the answer to the formula is 0, how can I make it just show the cell as
> empty instead of actually putting a 0 in the cell?

Either use a formula like =IF(B1-C1=0,"",B1-C1) or surpress all zeros with
Tools>Options>View and uncheck the Zero Values box

"t1202" wrote:

> If the answer to the formula is 0, how can I make it just show the cell as
> empty instead of actually putting a 0 in the cell?

> If the answer to the formula is 0, how can I make it just show the
> cell as empty instead of actually putting a 0 in the cell?

One way:
Tools >> Options >> View
And un-check "zero values."

Another way:
Format >> Conditional formatting
and set the font color to the background color when a cell is zero.

Another way:
=IF( <formula>=0, "", <formula> )

Another way:
Format >> Cells>> Number >> Custom
And put the following for Type:
###;-###;""

(I have Excel 97.)

Jay,

This is a nit, but the pair of quotes isn't really needed, as long as the
second semicolon is there.
###;-###;
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Jay" <[email protected]> wrote in message
news:[email protected]...
>> If the answer to the formula is 0, how can I make it just show the
>> cell as empty instead of actually putting a 0 in the cell?
>
> One way:
> Tools >> Options >> View
> And un-check "zero values."
>
> Another way:
> Format >> Conditional formatting
> and set the font color to the background color when a cell is zero.
>
> Another way:
> =IF( <formula>=0, "", <formula> )
>
> Another way:
> Format >> Cells>> Number >> Custom
> And put the following for Type:
> ###;-###;""
>
> (I have Excel 97.)