Excel errors, explained
Every error value Excel can show, in plain English: what it means, the usual causes with a small sheet where it happens, and how to fix each one. Got a formula that fails right now? The formula checker finds the part that breaks.
- #N/A: A lookup could not find the value it was given. 5 causes and fixes.
- #VALUE!: The formula was given the wrong kind of value, such as text where it needs a number. 6 causes and fixes.
- #REF!: The formula refers to a cell that no longer exists. 4 causes and fixes.
- #DIV/0!: The formula divides by zero or by an empty cell. 3 causes and fixes.
- #NAME?: Excel does not recognise a word in the formula. 6 causes and fixes.
- #NUM!: The calculation has no valid number as its answer. 5 causes and fixes.
- #SPILL!: A formula that returns several values has no room to put them. 4 causes and fixes.
- #CALC!: A formula that returns a list ended up with nothing to return. 2 causes and fixes.
- #NULL!: Two ranges that were expected to cross do not. 3 causes and fixes.
- #####: The column is too narrow to show the number, or a date is negative. 2 causes and fixes.
- Circular reference: A formula depends on its own result. 3 causes and fixes.