Practice free

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.

Practice free