#Div/0 error handling

In my worksheet I want to average the range(C5:C35), yet suppress the #Div/0 error. The code below is not working.
=if(ISERROR(Average(C5:C35),"",Average(C5:C35)))

Open in new window

Frank FreeseAsked:
Who is Participating?
 
Gerwin Jansen, EE MVEConnect With a Mentor Topic Advisor Commented:
Try this:

=ifERROR(Average(C5:C35),"")
0
 
Frank FreeseAuthor Commented:
Looks good - thank you
0
 
Frank FreeseAuthor Commented:
thank you
0
 
Saqib Husain, SyedEngineerCommented:
The mistake in your original formula is the location of the bracket

=if(ISERROR(Average(C5:C35),"",Average(C5:C35)))
should be
=if(ISERROR(Average(C5:C35)),"",Average(C5:C35))
0
 
Frank FreeseAuthor Commented:
Saqib,
Thank you for pointing that out
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.