What is #div 0 error in Excel?

TrustPilot

starstarstarstarstar Excellent

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?

Read forum post

 

 

Live dates & prices

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


TrustPilot
TrustScore 9.6       1034 reviews