Home |
Search |
Today's Posts |
#1
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
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
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
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
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Divide By | Excel Discussion (Misc queries) | |||
divide by zero | Excel Discussion (Misc queries) | |||
divide | Excel Discussion (Misc queries) | |||
divide by 0 | Excel Worksheet Functions | |||
Divide one row over other row I dont wont to divide one number | Excel Discussion (Misc queries) |