Prev: Three Variable Correlation
Next: Calculate Holiday
From: joey_boy on 17 May 2010 07:48 =(SUM(E98:F98)+D98/2)/(I98G98) 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.
From: Dave Peterson on 17 May 2010 07:59 Check your earlier post. On 05/17/2010 06:48, joey_boy wrote: > =(SUM(E98:F98)+D98/2)/(I98G98) > > 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.
From: sidm via OfficeKB.com on 17 May 2010 08:00 joey_boy wrote: >=(SUM(E98:F98)+D98/2)/(I98G98) > >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)/(I98G98)),0,((SUM(E98:F98)+D98/2)/(I98G98))  Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/msexcel/201005/1
From: sidm via OfficeKB.com on 17 May 2010 08:00 joey_boy wrote: >=(SUM(E98:F98)+D98/2)/(I98G98) > >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)/(I98G98)),0,((SUM(E98:F98)+D98/2)/(I98G98))  Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/msexcel/201005/1
From: sidm via OfficeKB.com on 17 May 2010 08:00 joey_boy wrote: >=(SUM(E98:F98)+D98/2)/(I98G98) > >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)/(I98G98)),0,((SUM(E98:F98)+D98/2)/(I98G98))  Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/msexcel/201005/1

Pages: 1 Prev: Three Variable Correlation Next: Calculate Holiday 