<div>
=IFERROR(SUM(($B$34)/($B$3<wbr />3)),&quot;0&quot;) <br />
=IFERROR(SUM(($B$34)/($B$3<wbr />3)),&quot;END OF MONTH&quot;) <br />
=IFERROR(SUM(($B$34)/($B$3<wbr />3)),0) <br />
<br />
<br />
These all get the error #NAME?<br />
<br />
Why?
</div>


=IFERROR(SUM(($B$34)/($B$33)),"0")
=IFERROR(SUM(($B$34)/($B$33)),"END OF MONTH")
=IFERROR(SUM(($B$34)/($B$33)),0)


These all get the error #NAME?

Why?

<div>
Hi<br />
I copied and pasted from my spreadsheet directly onto here<br />
<br />
=IFERROR(SUM(($B$34)/($B$3<wbr />3)),0)<br />
=IFERROR(SUM(($B$34)/($B$3<wbr />3)),&quot;0&quot;)<br />
=IFERROR(SUM(($B$34)/($B$3<wbr />3)),&quot;END OF MONTH&quot;)<br />
<br />
Both dont work
</div>


Hi
I copied and pasted from my spreadsheet directly onto here

=IFERROR(SUM(($B$34)/($B$33)),0)
=IFERROR(SUM(($B$34)/($B$33)),"0")
=IFERROR(SUM(($B$34)/($B$33)),"END OF MONTH")

Both dont work

<div>
<div class="content wysiwyg-content">
Hi guys whats the syntax trap Div/0 errors <br />
<br />
=SUM(($B$34)/($B$33)) &lt;===== else 0<br />
<br />
<br />
Thanks
</div>
</div>


Hi guys whats the syntax trap Div/0 errors 

=SUM(($B$34)/($B$33)) <===== else 0


Thanks

Division by 0 error check

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