B
Bryce
I want the cells to display no number, not even a zero, if there is no
value. How can I do this?
value. How can I do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
=IF(formula=0,"",formula)
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.
The trailing semicolon indicates that zeros are not to be displayed.
Or---
Tools/Options/View/deselect Zero Values.
D
Dan E
Bryce,
=IF(SUM(A1:A10)=0,"",SUM(A1:A10))
Dan E
=IF(SUM(A1:A10)=0,"",SUM(A1:A10))
Dan E
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 *
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 *
P
Paul
Bryce said:I want the cells to display no number, not even a zero, if there is no
value. How can I do this?
Tools > Options > View tab
Uncheck zero values.
B
Bryce
thanks everyone. those were mighty fast replies!