What does #DIV/0! mean in Google Sheets?
#DIV/0! appears when a formula divides by zero or by an empty cell treated as zero. It is common in conversion rate, cost-per-unit, and percent-change columns when the denominator can be blank on new rows.
When to use it
Learn #DIV/0! when building KPI ratios, commission math, and year-over-year percent change where the prior period may be zero or missing.
When to skip it
Do not hide every #DIV/0! without showing analysts that the denominator was zero. Sometimes blank is better than a fake zero percent.
How it works
-
1
Find the denominator cell referenced in the division formula.
-
2
Wrap with IF(denominator=0, "", numerator/denominator) or IFERROR for display-friendly blanks.
-
3
Use COUNTIF or LEN to require a non-empty denominator before calculating.
-
4
For percent change, handle prior period zero with a text note like "N/A" instead of infinity.
-
5
Protect denominator columns with validation so zero is only entered intentionally.
-
6
Document which rows are allowed to have zero denominators for reporting.
Examples in Google Sheets
Conversion rate
=Clicks/Visits returns #DIV/0! when Visits is 0 on a new campaign row.
Average when count is zero
AVERAGEIF with no matching rows can interact with ratios that still divide manually.
Percent of total
Part/Total shows #DIV/0! when Total is blank on a template row waiting for data.
Better Sheets resources
Common mistakes
-
Using IFERROR to show 0% when the denominator is zero, which misstates performance.
-
Dividing by a lookup that returns blank instead of checking ISBLANK first.
-
Dragging ratio formulas before denominator columns are filled on new rows.
-
Mixing percent formatted cells with raw decimals in the same denominator column.
-
Forgetting that empty cells are treated as zero in division.
Frequently asked questions
- Is empty cell the same as zero for division?
- Yes in most division formulas. An empty denominator triggers #DIV/0!.
- IFERROR vs IF for #DIV/0!?
- IF on denominator=0 is explicit. IFERROR catches any error but hides other problems.
- Can AVERAGE return #DIV/0!?
- AVERAGE of no numbers can error. AVERAGEIF with zero matches behaves differently than division.
- Why #DIV/0! in percent change?
- Prior value was zero so (new-old)/old divides by zero.
- How do I show a dash instead?
- Use IF(denominator=0, "-", numerator/denominator).
- Does ARRAYFORMULA spread #DIV/0!?
- Yes row by row when any denominator is zero.
- Can charts plot #DIV/0!?
- Usually gaps appear. Clean the source column first.
- How do I audit all #DIV/0!?
- Find #DIV/0! or add a helper with IFERROR(ERROR.TYPE(...)).
Related Tutorials
Watch how #DIV/0! error works
Most Common Errors and How To Handle Them in Google Sheets
Related blog posts
Guides that explain #DIV/0! error in more depth.
Related terms
KPI tracking
KPI tracking means choosing a small set of numbers that show whether you are winning, then updating them on a rhythm everyone trusts. In Sheets, each KPI usually has a definition, data source, target, and actual cell on a dashboard fed by formulas, not hand-typed guesses.
Read guide →win rate tracking
Win rate tracking measures how many opportunities close as wins versus losses or open deals. In Google Sheets you store one row per deal with Stage, Outcome, and Close date columns, then use COUNTIFS or pivot tables to calculate win percentage by rep, product, or quarter. A clear tracker turns pipeline rows into leadership-ready close rate metrics without exporting to a CRM report.
Read guide →#VALUE! error
#VALUE! means Google Sheets cannot interpret an argument as the type the function expects. Common causes include text in a math formula, invalid dates, wrong delimiter locale, or passing a range where a scalar is required.
Read guide →Google Sheets formula syntax
Every formula starts with = followed by a function name and arguments in parentheses. Ranges use A1 notation, text sits in quotes, and operators like + and & combine values. Sheets recalculates when inputs change, so syntax errors show as #NAME? or #ERROR! in the cell.
Read guide →Done reading about #DIV/0! error?
Membership unlocks 600+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.