## What is Div/0! Error in Excel?

#DIV/0! is the division error in excel and the reason why it occurs because when we divide any number by zero we get his error so this is the reason error appears as #DIV/0!.

For example when you want to find the student grade percentage you need to have two things, one is what was the total marks for the exam written and what is the achieved score in the examination, so with these two numbers, we can find the grade percentage.

- But look at the below scenario.

In the above image, John has achieved 85 marks but we don’t have a total exam score and we need to calculate the percentage of student John.

- To arrive percentage we need to divide the
**achieved score**by**exam score**so apply the formula as**B2 / C2**.

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

Since we do not have any value in C2 cell we got this error, because if you divide any number by empty cell or zero value cell we get this error.

### Scenarios of Getting “#DIV/0!” in Excel

Below are examples regarding #Div/0 error in excel.

As we have seen above #DIV/0! The error occurs when we divide the number by empty cell or zero value in excel but there are many other situations we will get this error, let’s look at them in detail now.

#### #1 – Dividing by Zero

- Look at the below formula image.

As you can see above we have two #DIV/0! Error-values in cells D2 & D5 the reason for this is in cell C2 we have not valued, so becomes empty cell and in C5 cell have zero value so leads to #DIV/0! Error.

4.9 (1,353 ratings) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion

#### #2 – Summing Cells

- Look at the below image.

In 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. The reason for this error is because in the range of cells from B2 to B6 we have got at least one division error of #DIV/0! In cell B4, so the eventual result of SUM function to 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. When we try to find the average for blank or empty cells we get this error.

- Now, look at the below example.

In this scenario too we have got #DIV/0! Error because in the formula range from B2 to B6 there isn’t any single numerical value since all the values are non-numerical values we got this division error.

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

In the first table, we have the city-wise temperature on two consecutive dates, and on the second table, we are trying to find the average temperature of each city and applied the AVERAGEIF function.

But for the city “Surat” we have got #DIV/0! Error because in the original table there is not city name “Surat” so when we try to find the average for the city which doesn’t exist in the actual table we get this error.

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

Now we know in what are the scenarios we get this error, now let’s 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 kind of error, instead of getting #DIV/0! The 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 get the error of #DIV/0!.

#### #2 – Use IF Function

We can also use the IF function in excel to tackle 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 then return the result as “0” or else return 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! When the range of cells supplied to the AVERAGE function has not even single numerical values.
- SUM function returns #DIV/0! Error if the range of supplied to SUM function has at least one #DIV/0! Value in it.

### Recommended Articles

This has been a guide to excel #div/0. Here we discuss examples of #div/0 error and how to tackle this error in excel along with examples and downloadable excel template. You may also look at these useful functions in excel –

- 35+ Courses
- 120+ Hours
- Full Lifetime Access
- Certificate of Completion