In this this tutorial we learn how to remove this error from **Excel** by following the steps below but first let’s have a look at an example dataset with **#DIV/0! Error**. This dataset above is related to school which contains student **Marks of Different Subjects,** **Total Subjects** and **Average Marks**.

When you perform calculations in **Excel**, you may sometimes encounter the “**#DIV/0!**” error message. This error occurs when a formula attempts to divide a number by zero, which is not a valid operation. While the error message itself can be useful in some cases, it can also be distracting and make it difficult to read or interpret your data.

### Step 1 – Use the formula given below.

– To remove **#DIV/0!** Error from the **Average Marks** column we will use a different formula.

– Syntax of the formula is**=IFERROR(Formula, Value in place of #DIV/0! error )**

– In our case the formula will be**=IFERROR( SUM(B2:D2)/E2, “INVALID” )**

– This formula will change all **#DIV/0!** errors to **INVALID.**

### Step 2 – Apply the formula to all the cells.

– Apply the formula used above to the rest of the cells in the column.

– Select the cell with the new formula and drag it from bottom right to the rest of the values.

– All the **#DIV/0! **Error will change to **INVALID**.