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

[Guest]

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]

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

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?

 

[Alan]

In say A1
=IF(B1+B2=0,"",B1+B2)
Regards,
Alan

 

[Guest]

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

 

[Jay]

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.)

 

[Earl Kiosterud]

Jay,

This is a nit, but the pair of quotes isn't really needed, as long as the
second semicolon is there.
###;-###;