Suppress Zero

  • Thread starter Thread starter Mark
  • Start date Start date
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
 
Somthing like the below

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

If this post helps click Yes
 
Back
Top