Resources > Formula Help
How Do I Fix #DIV/0! Errors in Excel?
Last Updated: June 2026
Quick Answer
A #DIV/0! error means your formula is trying to divide by zero or by a blank cell.
Example
=A2/B2
If B2 is blank or zero, Excel returns #DIV/0!.
Fix with IFERROR
=IFERROR(A2/B2,0)
Fix with IF
=IF(B2=0,0,A2/B2)
Which Fix Should You Use?
- Use IFERROR for a simple cleanup.
- Use IF when you specifically want to test for zero.
