Getting rid of #DIV/0!

[TLB129]

Here is my current formula:

=SUM(D5-C5)/C5

How do I get rid of #DIV/)!? Thanks so much!

 

[VoG]

Try

=IF(C5=0,"",(D5-C5)/C5)

 

[JackDanIce]

Change C5 to any value other than 0

Or:

=IF(C5=0,"",(D5-C5)/C5)

Out of curiosity why are you using SUM(D5-C5) instead of just (D5-C5), can't see a reason to be using another calculation in your formula...

 

[TLB129]

Thank you!!! It worked perfectly.

 

[Sektor]

=iferror(sum(d5-c5)/c5, 0)

 

[TLB129]

Because I'm an idiot and thought that I had to.... Thanks for the info.