Excel errors
Draft. This page's introduction is a placeholder until the launch batch writes it.
When a formula cannot return a result, Excel shows an error value that starts with a hash sign. Each page here explains one of them: what it means, the usual causes and the fix.
Error values
Find the exact text your cell shows.
-
#N/AA lookup found no match, or a value is marked not available.Page coming -
#VALUE!An argument is the wrong type, such as maths on text.Page coming -
#REF!A reference points nowhere: a deleted row or column, or an index past the end of a range.Page coming -
#DIV/0!The formula divided by zero or by an empty cell. -
#NAME?Excel doesn't recognise a name: a misspelled function, an undefined name, or text without quotes.Page coming -
#SPILL!A formula that returns several values can't spill because cells are in the way.Page coming -
#NUM!Impossible maths, such as the square root of a negative, or a number too big to hold.Page coming -
#NULL!A space between two ranges that don't overlap.Page coming -
#CALC!The calculation has nothing to return, such as FILTER with no matches and no fallback.Page coming -
####Not an error: the column is too narrow for the number, or a date or time is negative.Page coming
Practice it for real
Short drills in an Excel-style grid, checked the moment you press Enter.