ExcelBanter - #DIV/0! Error

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - #DIV/0! Error (https://www.excelbanter.com/excel-discussion-misc-queries/48395-div-0-error.html)

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kenny16301 via OfficeKB.com" <u14535@uwe wrote in message
news:554edbdf1ad94@uwe...
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

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

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kenny16301 via OfficeKB.com" <u14535@uwe wrote in message
news:554edbdf1ad94@uwe...
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