99.4% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
What is #div 0 error in Excel?
When you try to divide by 0 (zero) or a blank cell, Microsoft Excel displays the error value "#DIV/0!" as the result of the calculation.
eg. Cell A1 has a number 22, Cell A2 has 0 (or is blank). When a formula is written in Cell A3 as =A1/A2 the error #DIV 0 will appear.
You can use the built in Formula Audit function to help understand error codes.
Related forum posts:
I there an easy way to find errors in formulas between different excel workbooks?
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Any suggestions, questions or comments? Please post in the Improve the forum thread.