All in One Bundle

#DIV/0! Excel Error

Written by ExcelMojo Team ExcelMojo Editorial Team Editorial Team The ExcelMojo Editorial Team creates and improves practical Excel, VBA, Power BI, analytics, and AI spreadsheet resources for learners, analysts, teams, and business professionals. Excel VBA Power BI View Full Bio
Reviewed by Dheeraj Vaidya, CFA, FRM Dheeraj Vaidya, CFA, FRM Co-Founder & Course Director Dheeraj is the founder of ExcelMojo and leads the learning direction across Excel, analytics, financial modeling, valuation, and AI spreadsheet workflows. A former J.P. Morgan and CLSA equity... Financial Modeling Valuation Investment Banking View Full Bio
Updated Apr 23, 2026
Read Time 7 min

What Is A #DIV/0! Error In Excel?

The Division Error or the #DIV/0! Error in Excel is the error that occurs when we divide any cell value or cell reference by zero or a blank cell, or if any cell reference of a formula contains the #DIV/0 error.

For example, we will apply the #DIV/0! Error to calculate the error values as the output.

#DIV/0! Excel Error - 1

Select cell A2, enter the formula =10/0, and press “Enter”.

#DIV/0! Excel Error - 2

The result is returned as ‘#DIV/0!’ error’, as shown above.

Download FREE #DIV/0! Excel Error Template and Follow Along!

Use this #DIV/0! Excel Error Template to follow along with the examples in this article.

Download Excel Template

Key Takeaways

  • The #DIV/0! error is caused by dividing by zero but can also be generated due to other formulas referencing cells that display the #DIV/0! error.
  • It is useful because it tells that something is missing or unexpected in the data. 
  • It also appears when data is entered but is not yet complete or any blank cell because it is not yet available.
  • If a blank cell is left in the data and division calculation is to be performed, Excel considers the blank cell value as 0, and the evaluated result will generate #DIV/0! Error.

Scenarios Of Getting “#DIV/0!” In Excel

During Excel calculations, we get “#DIV/0!” in the following scenarios,

  • Dividing by Zero.
  • Summing Cells.
  • AVERAGE Function.

#1 – Dividing by Zero

We will perform calculations and generate the #DIV/0! Excel Error for the Dividing by Zero scenario.

In the table, the data is,

  • Column A contains the Values.
  • Column B contains the Output.
#DIV/0! Excel Error - Dividing by Zero

The procedure to get the #DIV/0! Error is as follows:

Select cell B2, enter the formula =A2/A3, and press the “Enter” key.

Dividing by Zero - Step 1

The result is a “#DIV/0!” error, as shown above.

#2 – Summing Cells

We will perform calculations and generate #DIV/0! Excel Error for the Summing Cells scenario.

In the table, the data is,

  • Column A contains the Values.
  • Column B contains the Output.
#DIV/0! Excel Error - Summing Cells

The steps to get the #DIV/0! Error are as follows:

  • Step 1: Select cell B2, and enter the formula =SUM(A2:A7), to calculate the sum of the values.
Summing Cells - Step 1
  • Step 2: Press the “Enter” key. The result is a “#DIV/0!” error, as shown below.
Summing Cells - Step 2

#3 – AVERAGE Function

We will perform calculations and generate #DIV/0! Excel Error for the AVERAGE Excel Function scenario.

In the table, the data is,

  • Column A contains the Values.
  • Column B contains the Output.
#DIV/0! Excel Error - AVERAGE Function

The steps to get the #DIV/0! Error are as follows:

  • Step 1: Select cell B2, and enter the formula =AVERAGE(A2:A7), to calculate the average of the values.
AVERAGE Function - Step 1
  • Step 2: Press the “Enter” key. The result is a “#DIV/0!” error, as shown below.
AVERAGE Function - Step 2

How To Fix “#DIV/0!” Error In Excel?

We can fix the “#DIV/0!” error in Excel using the IFERROR(), ISERROR(), and IF() functions.

#1 – Remove #DIV/0! Error Using IFERROR

We will use the IFERROR function in Excel to remove the #DIV/0! error.

In the table, the data is,

  • Column A contains the Values.
  • Column B contains the Output.
How to Fix #DIV0! Error in Excel - Using IFERROR

The steps to remove the #DIV/0! Error using the IFERROR() are as follows:

  • Step 1: Select cell B2, enter the formula =SUM(A2:A3)/0, press the “Enter” key, and drag the formula from cell B2 to B3 using the fill handle. The results are “#DIV/0!” error, as shown below.
Using IFERROR - Step 1
  • Step 2: Let us fix the result in cell B3, to understand the difference.

Select cell B3, enter the formula =IFERROR(SUM(A2:A3)/0,“Sum is Divided by 0”), and press the “Enter” key. The result is the “Sum is Divided by 0”, as shown below.

Using IFERROR - Step 2

#2 – Remove #DIV/0! Error Using IF

We will use the IF function in Excel to remove the #DIV/0! error.

In the table, the data is,

  • Column A contains the Values.
  • Column B contains the Output.
How to Fix #DIV/0! Error in Excel - Using IF

The steps to remove the #DIV/0! Error using the IF() are as follows:

  • Step 1: Select cell D2, enter the formula =C2=B2/C2, and press the “Enter” key. We will get an error pop-up, click “OK”. The result is a “#DIV/0!” error, as shown below.
Using IF - Step 1
  • Step 2: Let us fix the result in cell D2, to understand the difference.

Select cell D2, enter the formula =IF(C2=0,0,B2/C2), press the “Enter” key, and drag the formula from cell D2 to D3 using the fill handle. The results are “0”, and “0.8”, as shown below.

Using IF - Step 2

#3 – Remove #DIV/0! Error Using ISERROR

We will use the ISERROR function in Excel to remove the #DIV/0! error.

In the table, the data is,

  • Column A contains the Values.
  • Column B contains the Output.
How to Fix #DIV/0! Error in Excel - Using ISERROR

The steps to remove the #DIV/0! Error using the ISERROR() are as follows:

  • Step 1: Select cell B2, enter the formula =A2/A3, and press the “Enter” key. The result is a “#DIV/0!” error, as shown below.
Using ISERROR -Step 1
  • Step 2: Next, select cell B3, enter the formula =ISERROR(B2), and press the “Enter” key. The result is “TRUE”, as shown below.
Using ISERROR -Step 2

Find All Cells With #DIV/0! Excel Error

The steps to Find All Cells With #DIV/0! Excel Errors are as follows:

  1. We must first open the file where we want to remove the #DIV/0! Errors. Then, press the “CTRL+F” keys, i.e., the shortcut keys to open the “Find and Replace” dialog box in Excel.
Find All Cells With #DIV0! Excel Error - Step 1
  1. Click on the “Options” button, which shows additional options.
Find All Cells With #DIV0! Excel Error - Step 2
  1. In the ‘Find what:’ box, type #DIV/0!
Find All Cells With #DIV0! Excel Error - Step 3
  1. From the ‘Within’ drop-down with the Sheet or Workbook options, select the “Sheet” option.
Find All Cells With #DIV0! Excel Error - Step 4
  1. From the ‘Look in’ drop-down, select the ‘Values’ option.
Find All Cells With #DIV0! Excel Error - Step 5
  1. Click on “Find All”, which will find all the cells that have the #DIV/0! error, as shown below.
Find All Cells With #DIV0! Excel Error - Step 6

Important Things To Note

  • We get a #DIV/0! error in the AVERAGE function when the dataset does not have any numerical value.
  • The #DIV/0! error occurs in the SUM excel function when the selected cell range has one or more of the cell values as the #DIV/0! value in it.
  • We can avoid getting a #DIV/0! Error by making sure that a division calculation doesn’t have the divisor as 0 or the excel cell reference for the divisor is not a blank cell or 0.

Frequently Asked Questions (FAQs)

1. DIV/0! Error and Blank cells?

Let us consider an example where we get a #DIV/0! Error due to blank cells.

We will first divide the values, and generate the #DIV/0! Excel Error when the reference cell is passed is blank.

In the table, the data is,
• Column A & B contains the Values.
• Row 3 contains the Output.

#DIV0! Excel Error - FAQ 1

The procedure to get the #DIV/0! Error with a blank cell is,

Select cell B3, enter the formula =A2/B2, and press the “Enter” key.

FAQ 1 - Step 1

The result is a “#DIV/0!” error, as shown above.

2. What does the #DIV/0! in Excel mean?

The #DIV/0! in Excel means that there is a division error in the formula or the cell reference, such as a number divided by zero, or the dataset has a blank cell, or the result of the formula is zero, which is the number getting divided.

3. How to show a Zero instead of #DIV/0! Error?

We can display a Zero instead of #DIV/0! Error as follows:

First, create a data table, as shown below.

#DIV0! Excel Error - FAQ 3

Next, choose cell B3 → select the “Formulas” tab → go to the “Function Library” group → click the “Insert Function” option on the far left, as shown below.

FAQ 3 - Step 1

The “Insert Function” window appears. In the “select a category:” drop-down, select the “Logical” option, as shown below.

FAQ 3 - Step 2

Now, the options change in the “Select a function:” group, then select the IF function, and close “OK”, as shown below.

FAQ 3 - Step 3

Once we click “OK” in the “Insert Function” window, the Function Arguments window appears.

Enter in the Logical_test field as A2=0, the Value_if_true field blank, the Value_if_false field as B2/A2, and click “OK”, as shown below.

FAQ 3 - Step 4

So the complete formula will be =IF(A2=0,,B2/A2). We will get the result ‘0’, as shown below.

FAQ 3 - Step 5

Download FREE #DIV/0! Excel Error Template and Follow Along!

Use this #DIV/0! Excel Error Template to follow along with the examples in this article.

Download Excel Template