how to improve this

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, is there any way I can optimize this IF

=IF(SUM(A1:A9)<>0;SUM(A1:A9);"") (if sum is zero I don't want zero to be displayed

I don't want SUM(A1:A9) to be calculated twice

Than

alekm
 
A few options...

1] Just...

=SUM(A1:A9)

Format the formula cell as [=0]"";General

2]

Y2:

=SUM(A1:A9)

X2:

=IF(X2,X2,"")

3] Install the morefunc.xll add-in & use:

=IF(SETV(SUM(A1:A9)),GETV(),"")
 
Hi
one way:
enter the formula
=SUM(A1:A9)
in your cell and format this cell with the custom format:
#,##0.00;-#,##0.00;


Note: If this is your real formula you won't notice any
differences in calculation speed (as you use a small range
for your SUM function).
 
Just use
=SUM(A1:A9)
and format the cell with a custom number format that doesn't display zero
values, such as:
General;-General;;
 
Back
Top