Divide by 0 Help

J

joey_boy

=(SUM(E98:F98)+D98/2)/(I98-G98)

Any suggestions on how I can rewrite this to return 0 if I get a Dicide by 0
Error in any of the calculations. I am a bit of a novice.
 
S

sidm via OfficeKB.com

joey_boy said:
=(SUM(E98:F98)+D98/2)/(I98-G98)

Any suggestions on how I can rewrite this to return 0 if I get a Dicide by 0
Error in any of the calculations. I am a bit of a novice.
Click to expand...

=if(iserr(SUM((E98:F98)+D98/2)/(I98-G98)),0,((SUM(E98:F98)+D98/2)/(I98-G98))
 
S

sidm via OfficeKB.com

joey_boy said:
=(SUM(E98:F98)+D98/2)/(I98-G98)

Any suggestions on how I can rewrite this to return 0 if I get a Dicide by 0
Error in any of the calculations. I am a bit of a novice.
Click to expand...

=if(iserr(SUM((E98:F98)+D98/2)/(I98-G98)),0,((SUM(E98:F98)+D98/2)/(I98-G98))
 
S

sidm via OfficeKB.com

joey_boy said:
=(SUM(E98:F98)+D98/2)/(I98-G98)

Any suggestions on how I can rewrite this to return 0 if I get a Dicide by 0
Error in any of the calculations. I am a bit of a novice.
Click to expand...

=if(iserr(SUM((E98:F98)+D98/2)/(I98-G98)),0,((SUM(E98:F98)+D98/2)/(I98-G98))
 
Top