How to remove an #div/0 error in Excel

 

At the very least the #div/0 error in Excel is annoying, perhaps because it highlights flawed logic. Often it will be unavoidable especially if the target cell is waiting for Input from the user. Fortunately is a reasonably easy fix.

How to fix the #div/0 error

The error occurs because of using a zero in your division as below.

The best way to solve this is with the IFERROR() function because the function evaluates the formula and returns a specific value if there is an error. It will replace the #DIV error with your chosen alternative, in most cases that should be a zero (avoid using text if you can) as per the below:

And there is your fix.

Back to blog