Divide by zero error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top