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

  • Thread starter Thread starter Bryce
  • Start date Start date
B

Bryce

I want the cells to display no number, not even a zero, if there is no
value. How can I do this?
 
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.
 
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 *
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Pivot Tables - do not display zero values 2
Displaying zeros in cells 2
how to display zero prefixes in worksheet cells such as phone numb 1
Custom Number Format for text 8
Formatting zeros as dashes 4
IF and THEN statements 5
Number Formatting 1
zeros show as dashes in spreadsheet, want to show 0. 2

Back
Top