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

T

t1202

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?
 
D

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?
Click to expand...
 
B

bigwheel

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
 
J

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?
Click to expand...

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

Earl Kiosterud

Jay,

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