|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 17th, 2010, 12:48 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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. 
|
|
#2
May 17th, 2010, 12:59 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.
|
|
#3
May 17th, 2010, 01:00 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
|
#4
May 17th, 2010, 01:00 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
|
#5
May 17th, 2010, 01:00 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
