Suppress Zero

M

Mark

Hi,
I was wondering if it were possible to suppress or hide the zero in an auto
sum formula, when there are no values entered in the range? To take it one
step further, would it be possible to delay the calculation until the User
selected the cell with the auto sum formula? This is purely for aesthetic
reasons and more of a curiosity than anything else. Thanks.
Mark
 
J

Jacob Skaria

Somthing like the below

=IF(SUM(A1:A10)=0,"",SUM(A1:A10))

If this post helps click Yes
 

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

Improving Nested Formula Calculation Efficiency 2
Excel 2007 charts: want to avoid zero values 1
How do I suppress a zero value or #VALUE! for a Pivot calculated i 9
Pivottable calculated item - how to suppress zero? 4
Flashing cells 0
First row where a cell is zero 2
Range reference in array formula 2
Finding the minimum value in a list but excluding zeros - a variationon an old problem 10

Top