CODEWITHSUNDEEP
excelexcel-formula
user8553155
user8553155

Reputation: 41

#DIV/0! Excel Mac 2011 and IFERROR

I am trying to solve the #DIV/0! error produced when a formula yields a "0" result. I'm using Excel 2011 for Mac.

Here is the original formula:

=SUM((AX11025*1)/AV11025)

And here is the modified formula to eliminate the #DIV/0 error:

=IFERROR((SUM(AX11025*1)/AV11025),SUM(AX425*1), 0)

Upvotes: 1

Views: 68

Answers (3)

Scott Craner
Scott Craner

Reputation: 152535

No need for SUM() and IFERROR only takes two arguments not three:

=IFERROR(AX11025*1/AV11025,0)

Upvotes: 1

Lew Perren
Lew Perren

Reputation: 1239

If denominator AV11025 is zero then first argument so avoiding divide by zero error, else second argument.

=IF(AV11025=0,SUM(AX425*1),(SUM(AX11025*1)/AV11025))

OR reading your comment to @Scott Craner answer, you could use:

=IF(AV11025=0,"0%",(SUM(AX11025*1)/AV11025))

OR if you need value for further calcs rather than string then as @A.Rashad said:

 =IF(AV11025=0, 0 ,(SUM(AX11025*1)/AV11025))

Upvotes: 1

A.Rashad
A.Rashad

Reputation: 1064

you can test for the denomination value as follows

=IF(AV11025=0,0,SUM((AX11025*1)/AV11025))

Upvotes: 1

Related Questions