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

Nested "If formula" - returns zero when reference cell is empty 2
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
File not found -- how to suppress 2
Conditional Formatting with VBA 4
clear formula that does not return a value automatically? 4
How do I suppress a zero value or #VALUE! for a Pivot calculated i 9
Formula appearing as Value in Formula Bar 1
Formulas Not Calculating in Excel 2003 1

Top