Cell to remain blank if value is 0

[tdog72]

Good afternoon. I'm looking for some help with an IF statement. My formula is =sum(k2:k13)/sum(j2:j13). If the result of this is zero I want the cell left blank so it will not produce a div/0 error when I link the cell to another spread sheet. Can you help me please?

 

[jtakw]

Hi,

You can wrap your formula with IFERROR:

=IFERROR(SUM(K2:K13)/SUM(J2:J13),"")

 

[Scott Huish]

IFERROR won't return blank for 0 if the problem is not in the denominator. (Say, the sum of K2:K13 was 0, but the sum of J2:J13 was 7)
However referencing a cell with "" will cause a #VALUE ! error if you do math with that result.

In General, you want to check for a 0 denominator:
=IF(SUM(J2:J13),SUM(K2:K13)/SUM(J2:J13),"")

Then you're next formula needs to check for the value in that cell before you do math on it.

But to incorporate that into what you asked:
=IF(SUM(J2:J13),IF(SUM(K2:K13)/SUM(J2:J13)=0,"",SUM(K2:K13)/SUM(J2:J13)),"")