#Div/0! Excel Error

Last Updated :

21 Aug, 2024

Blog Author :

Edited by :

Reviewed by :

Table Of Contents

What is Div/0! Error in Excel?

#DIV/0! is the division error in Excel. If we divide any number by zero, we get this error. So, this is why the error appears as "#DIV/0!"

For example, if we want to find the student grade percentage, we need the total marks for the exam written and the achieved score. So, with these two numbers, we can get the grade percentage.

But look at the below scenario.

John has achieved 85 marks in the above image, but we do not have a total exam score. And we need to calculate the percentage of a student, John.

We need to divide the achieved score by the exam score to arrive, applying the formula B2 / C2.

We have got the division error as #DIV/0!

We got this error since we do not have any value in the C2 cell. We get this error if we divide any number by an empty or zero-value cell.

What is Div/0! Error in Excel?

Scenarios of Getting "#DIV/0!" in Excel

Below are examples regarding the #Div/0 error in Excel.

As we have seen above, #DIV/0! The error occurs when Excel divides the number by an empty cell or zero value. But we can get this error in many other situations. Let us look at them in detail now.

#1 - Dividing by Zero

Look at the below formula image.

As we can see above, we have two #DIV/0! Error-values in cells D2 and D5 because in cell C2, we have no value. So, it becomes an empty cell. Cell C5 has zero value, leading to #DIV/0! Error.

#2 - Summing Cells

Look at the below image.

B7 cells have applied the SUM Excel formula by taking the range of cells from B2 to B6.

But, we have got a #DIV/0! Error. This error is because, in the range of cells from B2 to B6, we have at least one division error of #DIV/0! In cell B4, the eventual result of the SUM function is the same.

#3 - AVERAGE Function

Look at the below formula image.

In cell B7, we have applied the AVERAGE function to find the average score of students.

But the result is #DIV/0! Error. We get this error when we try to find the average for blank or empty cells.

Now, look at the below example.

In this scenario, too, we have got #DIV/0! Error because there is no single numerical value in the formula range from B2 to B6. Since all the values are non-numerical, we got this division error.

A similar set of division errors occurs with the AVERAGEIF function in excel as well. For example, look at the below example.

We have the city-wise temperature on two consecutive dates in the first table. We tried to find each city's average temperature in the second table and applied the AVERAGEIF function.

But for the city "Surat," we have got #DIV/0! Error because there is no city name "Surat." In the original table, we get this error when we try to find the average for the city that does not exist in the actual table.

How to Fix "#DIV/0!" Error in Excel?

Now we know in what scenarios we get this error. So let us look at the ways of tackling this error in Excel.

#1 - Use the IFERROR Function

IFERROR in excel is the function specifically used to tackle any error. Instead of getting #DIV/0! Error, we can get the alternative result.

Look at the below image.

In the above function, we have used IFERROR to get the alternative result of "Denominator is Empty or Zero" whenever we got the #DIV/0! Error.

#2 - Use the IF Function

We can also use the IF function in Excel to test whether the denominator cell is empty or zero.

Look at the below scenario.

The above formula says if the denominator cell is equal to zero, return the result as "0" or the result of the division. Like this, we can tackle #DIV/0! Errors.

Things to Remember Here

The AVERAGE function returns the error of #DIV/0! Because the range of cells supplied to the AVERAGE function has not even a single numerical value.
SUM function returns #DIV/0! Error if the supplied SUM function range has at least one #DIV/0! Value in it.