How to fix #DIV/0! Error in Excel 2010

Solution to fix the #DIV/0! Error in Microsoft Excel

The error occurs when attempting to divide by 0, this is because mathematically dividing by 0 makes no sense and diverges to infinity

[danielziak]

I've see many stupid solutions, but this one made me write a comment.

[electiondepartmentjalpaigu]

This is not the way to resolve DIV/0 error try =iferror(cell1/cell2, 0). Supported by Excel 2007 onwards.

[bdavison]

But the number IS 0. I can't change it to be whatever I want.

[AmaanPetHouse]

This could never help in stock report sheet where so many items are 0 in opening balance.

[idoido]

Remove your video cause it´s the main error