A spreadsheet error can look like an interruption to tidy up. It is often more useful as a clue. A missing price, a deleted reference and a division by zero need different repairs, even if all three leave an ugly cell in a report.
Start by selecting the affected cell and reading the formula. Then follow the cells it depends on. Before changing anything important, work on a copy or use the application’s version history. The aim is to understand what the result was supposed to mean, not merely to remove a symbol.
DIV/0: ask what the denominator represents
Consider a fictional attendance sheet that divides the number of visitors by the number of sessions. If visitors are 12 and sessions are zero, the calculation cannot produce an average per session. Entering zero as the result would imply something different: that the average is known and equals zero.
Check whether the session count is genuinely zero, has not been entered yet, or points to the wrong cell. A blank input can also behave like zero in a division. Once you know the reason, choose a suitable display such as “not calculated yet” while preserving the distinction from a measured zero.
REF: inspect the address, not just the number
A reference error can appear when a formula depends on cells that are no longer available, including after a referenced column is deleted. Adding a new column with the same heading does not necessarily reconstruct the original formula.
Read the formula bar and compare the calculation with a neighbouring row that still works. Check version history if the intended reference is unclear. Do not drag a nearby formula across the whole sheet until you understand whether its relative and fixed references should change.
N/A: a lookup may have found no match
In a product-price lookup, a missing match could mean a new product has not been added to the price list. It could also reflect an inconsistent identifier or an unsuitable lookup setting. Inspect one failing record and its supposed source entry before editing many rows.
“No matching price” is not the same as “free”. Replacing every missing lookup with zero can quietly understate an order total. A visible label or separate review column keeps the unresolved record available for correction.
Use a tidy display after the diagnosis
Google Sheets’ ERROR.TYPE documentation lists distinct codes for these error categories. That distinction is useful even if you never use the function: the message narrows the investigation.
IFERROR can provide a readable fallback once you have decided which failures are expected. Applied too broadly, it can hide an accidental deletion alongside an ordinary missing value. Test the formula with a valid record, a genuinely missing record and an invalid input. A trustworthy sheet makes those situations understandable rather than making them all look successful.
AI-generated editorial illustration; not a documentary photograph.