Suppress Zero
 

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

Suppress Zero
 

Somthing like the below

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

If this post helps click Yes
---------------
Jacob Skaria


"Mark" wrote:

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

Suppress Zero
 

Thanks, Jacob. It worked great!
Mark

"Jacob Skaria" wrote:

Somthing like the below

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

If this post helps click Yes
---------------
Jacob Skaria


"Mark" wrote:

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