#DIV/0! Error

  • Thread starter Thread starter Kenny16301 via OfficeKB.com
  • Start date Start date
K

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
 
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
 
Another one is use formula as below:
=if(iserror(SUM(B14-C14)/B14), "", SUM(B14-C14)/B14)
 
Back
Top