View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Leigh Douglass Leigh Douglass is offline
external usenet poster
 
Posts: 1
Default Using ISERROR to Solve #DIV/0 in a formula

Hi

Apologies if i am repeating someone elses question, but can someone help me
enter the ISERROR function into this formula to get rid of the #DIV/0 message?

=IF(G43+C43=0,0,(G43/C43))

Basically cell C43 is a zero, so when the formula calculates the last
section I am getting the #DIV/0 error. Can I add the ISERROR function to
display a '0' instead or anything else for that matter?

Thanks in advance for your help.