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