Home |
Search |
Today's Posts |
#1
|
|||
|
|||
#DIV/0! Error
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Div/0 error | Excel Worksheet Functions | |||
DIV/0! error in SumProduct formula with no division | Excel Worksheet Functions | |||
replace "#DIV/0!" error with blanks | Excel Worksheet Functions | |||
# DIV/0! error in Excel | Excel Discussion (Misc queries) | |||
"Average" with error DIV/0 | Excel Discussion (Misc queries) |