Divide by 0 Help
 

=(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.

Divide by 0 Help
 

Check your earlier post.

On 05/17/2010 06:48, joey_boy wrote:
=(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.

Divide by 0 Help
 

joey_boy wrote:
=(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.

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201005/1

Divide by 0 Help
 

joey_boy wrote:
=(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.

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201005/1

Divide by 0 Help
 

joey_boy wrote:
=(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.

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201005/1