98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Topics » What is #div 0 error in Excel?
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:
Tracking formula errors in Excel
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). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
