#DIV/0!Supported on: Microsoft Excel® & Google Sheets™

How to Fix the #DIV/0! Error in Excel & Google Sheets

The #DIV/0! error occurs when a formula attempts to divide a number by zero (0) or by a blank/empty cell that the spreadsheet interprets as zero.

Common Root Causes of #DIV/0!

  • 1Explicitly dividing by 0 (e.g., =A1 / 0).
  • 2Dividing by a cell reference that is empty or contains zero.
  • 3Using AVERAGE() or AVERAGEIF() on a range where no cells meet the given criteria.

Formula Syntax Comparison

Broken Formula
=(Current_Revenue - Prior_Revenue) / Prior_Revenue
Corrected Formula
=IF(Prior_Revenue=0, 0, (Current_Revenue - Prior_Revenue) / Prior_Revenue)

Manual Step-by-Step Fix

1

Step 1

Check if the denominator cell contains valid non-zero data.

2

Step 2

Wrap the calculation in an IF check: =IF(B2=0, 0, A2/B2).

3

Step 3

Wrap in IFERROR: =IFERROR(A2/B2, 0).

Automate this Fix with SheetFactorys

Zero manual debugging required

SheetFactorys scans mathematical denominator references across all sheets and wraps susceptible ratios in conditional guards, preventing broken dashboards and KPI card calculations.

Available in Microsoft AppSource & Google Workspace
Install for Excel®Install for Sheets™