How to Solve #DIV/0! Error in Excel?

How To Solve Error #DIV/0! in Excel?

If you have been working in Mircosoft Excel then I am sure you have many face error #DIV/0! error.

In this tutorial, I will show how to remove the error using an easy formula.

What is #DIV/0! error?

In Microsoft Excel, we will get DIV error when we have a formula where there is division and divisor is 0.

Let’s understand with Example, If you enter =15/0 in a cell then it will give you a result division error (#DIV/0!).

DIV

Absolutely, we wouldn’t use a formula like this routine work. But in most of the cases, the error is the result of a larger formula where you are using cell references in the formula, and some fo reference cells could have the zero(0) value or could be blank.

Remove #DIV/o! Error by IFERROR Formula

If you are working with formulas and want to resolve error of #DIV/0! , you can use the IFERROR formula technique.

Below is the syntax of IFERROR formula.

=IFERROR(value, value_if_error)

Here:

Value: this is the formula that can be given an error of Divison error.

Value_if_Error: This is the value specified you should get if error occurred.

Let’s understand with an Example.

Suppose we have dataset as shown below where I have division formula in column D.

As we can see , we get div errors in all the cases where the divisor is Zero (0) or Blank in Column C.

DIV

To remove this error I will use below mentioned formula.

=IFERROR(C2/B2,””)

The above-mentioned formula returns the result value after division if it is not an error. and in case if there is an error then it replaces it with Blank.

DIV

Below is the formula that will give you the text “No Target” instead of the division error:

=IFERROR(A2/B2,”Not Target”)

#DIV/0!

  • IFERROR works for all the error values (including N/A, #DIV/0!, #VALUE!, #REF!, #NAME, #NUM, etc.). So in case, your formula returns any other error, it would also be treated the same way.

 

Reference: Trumpexcel.com