Divide by zero error

[jimmy]

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.

 

[Ragdyer]

Try this:

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