Prev: Drop down box!
Next: Three Variable Correlation
From: joey_boy on 17 May 2010 07:12
=(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
From: Dave Peterson on 17 May 2010 07:56
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
 | 
Pages: 1
Prev: Drop down box!
Next: Three Variable Correlation