No one likes to see that demented #DIV/0! Error in Excel spreadsheets and pivot tables! We know that dividing by a 0 value will equate to zero, so why does Excel not return what we want to see?
To fix #DIV/0! in a worksheet – Change your formula. In our example below, we are using the formula =M36896/L36896 to calculate a number formatted as a percentage. Since our numbers in columns M and L are blank, we get the #DIV/0! Error.
If we change our formula to use the IFERROR function, we can replace the error with our choice of 0 or a blank or even another word. The IFERROR function in the form of =IFERROR(M36896/L36896,0) will return a 0 instead of the error.
If you want to see something besides a 0, then use the text indicator of “something else” and the 0 would be changed to what you would like to see. Example, =IFERROR(M36896/L36896,”ERROR”) or =IFERROR(M36896/L36896,”**”), etc.
To fix #DIV/0! in a worksheet – Change your formula.