#DIV/0! Error in Google Sheets? Here’s The Fix Guide!

If A2 becomes zero or is blank, then it will result in an error #Div/0. If you use the formula =Iferror(A1/A2,”0″) then if A2 suddenly becomes blank or zero, instead of displaying an error it will display Division by Zero. The If Error function can also be used as the syntax =Iferror(value).