Excel error decoder
Pick the error your cell shows, or paste it. Optionally add the formula that produced it, and we'll point at the likely cause.
- #N/AThe formula couldn't find what it was asked to look for.Causes and fixes
- #VALUE!Something in the formula is the wrong type of value, usually text where a number should be.Causes and fixes
- #REF!The formula points at a cell that isn't valid any more.Causes and fixes
- #DIV/0!A number is being divided by zero or by an empty cell.Causes and fixes
- #NAME?The formula contains a word the spreadsheet doesn't recognise.Causes and fixes
- #NUM!A number in the formula (or its result) isn't valid for that calculation.Causes and fixes
- #SPILL!A formula returns several values, but Excel can't put them in the cells it needs.Causes and fixes
- #CALC!Excel's calculation engine hit a case it doesn't support, often an empty result.Causes and fixes
- #NULL!Two ranges are joined with a space, and they don't overlap.Causes and fixes
- #####Not a formula error: the column is too narrow, or a date is negative.Causes and fixes
- Circular referenceA formula refers to its own cell, directly or through other cells.Causes and fixes
- Formula shows as textThe cell shows the formula itself, not what it calculates.Causes and fixes
Errors are messages, not failures
Every spreadsheet error names what went wrong: #N/A couldn't find something, #DIV/0! divided by zero, #REF! lost a cell. Each has a short list of usual causes, and once you know them, most errors take seconds to fix.
For each error, the decoder ranks the causes from most to least common, shows a broken formula next to the fixed one, and explains how to hide the error safely when it's expected, without covering up real problems. Every claim links to Microsoft's or Google's own documentation.
Stuck on a long formula instead? The formula explainer breaks any formula down step by step.
Questions
What's the most common Excel error?+
#N/A from lookups that can't find their value, usually because of extra spaces, numbers stored as text, or a missing FALSE in VLOOKUP.
Should I wrap every formula in IFERROR?+
No. IFERROR hides every error, including typos and broken references, so wrong results go unnoticed. Fix the cause first; hide only errors you expect, as narrowly as you can (IFNA for #N/A, IF for a zero divisor).
Are errors the same in Excel and Google Sheets?+
Mostly. #N/A, #VALUE!, #REF!, #DIV/0!, #NAME?, #NUM! and #NULL! exist in both. #SPILL! and #CALC! are Excel's; Google's list of Sheets error values doesn't include them. Each error page notes the differences, with sources.
Does the formula check send my formula anywhere?+
No. It runs in your browser.
Practise this in 5 minutes
Start with Lesson 1 and build up from your first formula, on a live sheet with instant feedback.
Start the first lessonNeed a quick reference? The formula cheat sheet is free to read and print.