#DIV/0! Error

[Kenny16301 via OfficeKB.com]

Hi,

In the formula listed below sometimes I put zeroes in the 2 cells or I leave
them blank but I get the #DIV/0! error. How can I add the ISError function to
my formula. Its driving me crazy.

=SUM(B14-C14)/B14

Thanks In advance.
Kenny

 

[Bernard Liengme]

Firstly, you do not need SUM. This is used in formulas such as SUM(A1:A100)
to sum a range.
You need just = (B14-C14)/B14
But if B14 is zero you will get DIV error
So =IF(B14<>0,(B14-C12)/B14,"Zero value in B14")
best wishes

 

[Dan]

Another one is use formula as below:
=if(iserror(SUM(B14-C14)/B14), "", SUM(B14-C14)/B14)