#DIV/0 in Excel! How to handle error?
Braxorn · Last updated 2026-11-22 · English
#DIV/0! Indicates that a calculation is divided by zero or a null denominator that evaluates to zero. The correct process is to decide how to present the result by separating the missing data from the value that is actually zero.
What can you do?
- Find the denominator of the division and examine whether the cell is really empty or zero.
- If there is missing data, complete the source.
- If zero denominator is a valid condition, show an explanation in this case with a conditional formula; Continue the division process in normal condition.
A small example
Let B2 be the cost and C2 be the number of production. When C2=0, unit cost cannot be calculated. For example, =IF(C2=0,"Cannot Calculate",B2/C2) clearly shows this situation.
What to watch for
Making the denominator 1 or showing all errors as 0 may mislead the costs and rates. The description used must be compatible with the data type expected by subsequent formulas.
Check the result
Make three separate attempts for zero, null, and positive denominator.
Examples are synthetic. Formulas use English function names and comma separators; names or separators may differ with your Excel language and regional settings. Menus and features vary by version.
Microsoft source (English)
Review your own workbook
You can start reviewing your Excel file in Braxorn. Check which controls are supported and review incomplete checks alongside the report scope.
Review your file