formulastreak

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.

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 lesson

Get the formulastreak newsletter

Bite-sized formula tips you can use at work the next day, plus a heads-up when new free tools and lessons land. It arrives now and then, never in a flood.

No spam, unsubscribe in one click. We store your email, this consent and when you gave it. Details in our privacy policy.

Need a quick reference? The formula cheat sheet is free to read and print.