#DIV/0! appears when a formula divides by zero or by an empty cell, which is exactly what happens in a savings rate when income is zero or a percent change when last month was zero. The proper fix is an IF that tests the divisor first. A blanket IFERROR also removes the error, but it can hide other mistakes at the same time.
Where does #DIV/0! come from in a budget sheet?
Two formulas cause most of it. A savings rate is saved divided by income. A percent change is the change divided by last month. Both go wrong when the divisor is zero or blank, for example in a freelancer's month with no payment yet, or in the first month of a new category.
How do I write the savings rate safely?
Say income is in B2 and expenses in C2. The plain formula is =(B2-C2)/B2. With income of ₹60,000 and spending of ₹45,000, that is 15,000 divided by 60,000, which is 0.25 or 25 percent. Guard it with IF:
- =IF(B2=0,"no income",(B2-C2)/B2)
B2=0 is TRUE for a blank cell as well, so empty future months show "no income" rather than an error. Format the result as a percentage.
And a month-on-month percent change?
With last month's groceries in B3 and this month's in C3, use:
- =IF(B3=0,"n/a",(C3-B3)/B3)
If last month was ₹8,000 and this month is ₹9,200, the change is 1,200 divided by 8,000, which is 0.15, so up 15 percent. If last month was zero, a percent change has no meaning, and "n/a" tells the reader so.
Why is a blanket IFERROR risky?
IFERROR(formula,"") catches every error, not just #DIV/0!. Say you wrap the savings rate in it and later delete a column, so the formula gains a #REF!. The cell just goes blank, and you assume there is no data when the formula is actually broken. The same happens with #NAME? from a typo and #VALUE! from text in an amount.
| Method | Catches | Risk |
|---|---|---|
| =IF(B2=0,"n/a",(B2-C2)/B2) | Only the divide-by-zero case | Other errors still show, so you notice them |
| =IFERROR((B2-C2)/B2,"n/a") | Every error | A broken formula looks like a missing figure |
| No guard | Nothing | Ugly error, but honest |
If you do prefer IFERROR for brevity, use it only around the division itself on a formula you have tested, and keep the rest visible. Never put one around a whole row of sums.
What about averages that include those cells?
AVERAGE ignores text cells such as "n/a", which is usually what you want: twelve months with two empty ones average over ten. But arithmetic with + or * on a text cell gives #VALUE!, so keep calculations that feed on these columns separate from the display.
When should I not hide the error at all?
When a zero divisor means something is wrong, for example a total that should never be zero. Let the error show until you have worked out why. Hiding it makes the sheet look finished when it is not.
If you track income and spending from statements, SpendixAI's reports do the totals and overview for you, and a sheet can stay for ratios of your own.
Checklist
- Put IF(divisor=0,...) in front of each division.
- Choose a clear label such as "no income" or "n/a" instead of a blank.
- Use NA() if a chart reads the cell.
- Avoid IFERROR around whole formulas.
- Test the guard by typing zero into the income cell.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


