How to fix #DIV/0! in Excel and Google Sheets

What you see

• Cell shows #DIV/0!
• Formula divides one number by another

Common causes

• The bottom number (denominator) is zero or empty
• The cell you divide by is blank

How to fix it

1. Click the cell with the error
2. Use IF to check the denominator before dividing
3. Or leave the cell blank when there is nothing to divide by

Example formula

=IF(D2=0,"",C2/D2)