Divide by zero error
 

I am adding C14 & C15 in the formula. If C15 is blank or zero, I get the
error "Divide by zero error". The formula used in sheet one is
'=$C$20/($C$14+$C$15)/$C$16
C14 & C15 is also transfered to sheet 2 (C11 & C12) where C13 is (C11+C12).
Wondering what might be the best way to get rid of the error, and formulate
these 2 sheets.

--
jimmy

Divide by zero error
 

Try this:

=IF(OR(SUM(C14,C15)=0,C16=0),0,$C$20/($C$14+$C$15)/$C$16)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jimmy" wrote in message
...
I am adding C14 & C15 in the formula. If C15 is blank or zero, I get the
error "Divide by zero error". The formula used in sheet one is
'=$C$20/($C$14+$C$15)/$C$16
C14 & C15 is also transfered to sheet 2 (C11 & C12) where C13 is
(C11+C12).
Wondering what might be the best way to get rid of the error, and
formulate
these 2 sheets.

--
jimmy