if SUM = zero, then display nothing... how?

B

Bryce

I want the cells to display no number, not even a zero, if there is no
value. How can I do this?
 
B

Bob Umlas

Format the cells to something like General;General;
The trailing semicolon indicates that zeros are not to be displayed.
Or---
Tools/Options/View/deselect Zero Values.
 
A

A.W.J. Ales

Bryce,

Assuming that your formula is a SUM, use
If(SUM(...)=0,"",SUM(...))

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Top