ExcelBanter - Div 0 help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Div 0 help (https://www.excelbanter.com/excel-discussion-misc-queries/263907-div-0-help.html)

joey_boy

Div 0 help

=(SUM(E98:F98)+D98/2)/(I98-G98)

This formula gives me a Div 0 error. How can I re-write it so that it stores
a value of 0 , if it encounters a Divide by 0 and executes the calculation if
0
Help appreciated
Joe

Dave Peterson[_2_]

Div 0 help

maybe:

=if(i98=g98,0,sum(e98:F98,d98/2)/(i98-g98))

I combined your addition into the =sum() portion. I thought it made it easier
to read.

On 05/17/2010 06:12, joey_boy wrote:
=(SUM(E98:F98)+D98/2)/(I98-G98)

This formula gives me a Div 0 error. How can I re-write it so that it stores
a value of 0 , if it encounters a Divide by 0 and executes the calculation if
0
Help appreciated
Joe

All times are GMT +1. The time now is 09:07 AM.