IF Formulas

M

MrReeLady

I'm still relatively new to the formulas - can't do anything too complex yet
so this should be an easy one for all you experts out there.

I have cells that have basic Sum formula. If there is no value in any of
the preceding cells, the total cell shows $0.

I believe I can create a formula that says if the value is 0 then leave
blank. I don't want to see the $0.

Thanks!
 
P

PCLIVE

This says that if the sum of cells A1 through A10 equals zero, then return
nothing ( "" ), else return the sum of A1 through A10.

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

HTH,
Paul
 
F

FSt1

hi
replace your basic sum formaulas with this..
=if(Sum(A2:A10)=0,"",Sum(A2:A10))
or
=if(A9=0,"",A9)

lots of variations on this.

Regards
FSt1
 
D

David Biddulph

If you want to show a blank if the total is zero, then you could use
=IF(SUM(A2:A100)=0,"",SUM(A2:A100)) but this would give a blank if you have
genuine numbers that sum to zero.

If you want a blank result if all the input cells are blank, then try
=IF(COUNT(A2:A100),SUM(A2:A100),"")
 
E

EarlyBirdie

If it is merely a display of the value "0" that you want to eliminate but
don't care if the content of the cell is "0" then under Tools\Options\View
uncheck the Zero values box
 
Top