#div0

#DIV/0! Error in Excel and Google Sheets: Causes and Fixes

#DIV/0! appears when a formula divides by zero, a blank, or a text zero. Test 1/0, 0/0, MOD, and when IF is safer than IFERROR.