Excel errors explained with fixes you can test.
Lookup misses, wrong types, deleted references, blocked spills, and divide-by-zero. Each page shows the cause and a working formula.
Open the interactive error lab
Click a broken #REF!, #VALUE!, #DIV/0!, #SPILL!, or #CALC! sheet, copy the fix, and send that example into the formula fixer.
Start the lab#N/A
Excel #N/A Error: Causes and Proven Fixes
#N/A means Excel did not find a match. It is the expected lookup miss, not a broken workbook, until the miss is accidental.
Read guide- #VALUE!Excel #VALUE! Error: What It Means and Fixes#VALUE! means Excel received the wrong type of argument, often text where a number was required, or a FIND/MID position that does not exist.
- #REF!Excel #REF! Error: Broken References Explained#REF! means a cell reference no longer exists. Deleting a row, sheet, or copied range that a formula pointed to is the usual cause.
- #SPILL!Excel #SPILL! Error: Fix Blocked Array Formulas#SPILL! means a dynamic array formula cannot write into its output area because another value, merge, or Table is in the way.
- #DIV/0!Excel #DIV/0! Error: Divide by Zero Fixes#DIV/0! means a formula divided by zero or by a blank that Excel treats as zero. Guard the denominator before you hide the error.
- #NAME?Excel #NAME? Error: Unknown Function Fixes#NAME? means Excel does not recognize a name in the formula. A misspelled function or a Hungarian name in an English file is the usual cause.
- #NUM!Excel #NUM! Error: Impossible Number Fixes#NUM! means the calculation produced a number Excel cannot use, or an iterative function never settled on a result.
- #NULL!Excel #NULL! Error: Space Instead of a Range#NULL! means two ranges were written with a space and they do not overlap. You usually meant a comma or a plus sign.
Still stuck on the error?
Paste the formula, the error, and what should happen. Get a correction with an explanation.