<div>
The mistake in your original formula is the location of the bracket<br />
<br />
=if(ISERROR(Average(C5:C35<wbr />),&quot;&quot;,Avera<wbr />ge(C5:C35)<wbr />)) <br />
should be<br />
=if(ISERROR(Average(C5:C35<wbr />)),&quot;&quot;,Aver<wbr />age(C5:C35<wbr />))
</div>


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))

<div>
Saqib,<br />
Thank you for pointing that out
</div>


<div>
<div class="content wysiwyg-content">
In my worksheet I want to average the range(C5:C35), yet suppress the #Div/0 error. The code below is not working.<br />
=if(ISERROR(Average(C5:C35<wbr />),&quot;&quot;,Avera<wbr />ge(C5:C35)<wbr />))
<pre><code id="code-10-28416391-1"></code></pre>
</div>
</div>


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)))(CODE)

#Div/0 error handling

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.