Add to formula so cell doesnt show 0

[drop05]

Hello, what is the best way to get rid of 0s for formulas? I have a sum formula and since the cells they reference are blank since its a fresh workbook it is showing 0 and would rather it be blank

 

[Micron]

One way would be
= If(Sum(D2:D8) = 0,"")

 

[jtakw]

Hi,

You can change the settings in Excel to Hide 0 , or do this:

Book3.xlsx
	G	H	I	J	K
1	1	2		4	7
2
3		5			5
Sheet1044

Cell Formulas
Range	Formula
K1:K3	K1	=IF(SUM(G1:J1)=0,"",SUM(G1:J1))

 

[Micron]

Dang! I missed copying the rest of my formula. I had
=IF(SUM(D2:D8) = 0,"",SUM(D2:D8))

 

[drop05]

Dang! I missed copying the rest of my formula. I had
=IF(SUM(D2:D8) = 0,"",SUM(D2:D8))

All good, very helpful thank you!