Home / Guides / Excel Errors & Fixes

Understanding Excel Formula Errors (#REF!, #VALUE!, and More)

Beginner Excel Errors & Fixes Applies to: Windows 7, Windows 10, Windows 11

A quick reference for what each formula error actually means and the fastest way to fix it.

Before you start: save any open work and note down what you were doing when the problem started — that context helps if you need to search further or ask for help.
  1. #REF! means the formula points to a cell that no longer exists, usually because a row, column, or sheet it referenced was deleted — undo the deletion if possible, or rebuild the reference.
  2. #VALUE! means the formula received the wrong type of data, like adding text to a number — check every cell the formula references for stray text, spaces, or symbols.
  3. #DIV/0! means the formula is dividing by zero or an empty cell — wrap it in IFERROR() or check the denominator cell directly.
  4. #N/A means a lookup formula (VLOOKUP, MATCH, XLOOKUP) couldn't find a match — check for typos, extra spaces, or mismatched data types between the lookup value and the source range.
  5. #NAME? means Excel doesn't recognize text in the formula — usually a misspelled function name, a missing quotation mark, or a function from an add-in that isn't enabled.
  6. #NUM! means a formula produced a number too large or small for Excel to represent, or an invalid argument was passed to a function like SQRT of a negative number.
  7. #NULL! means you used a space instead of a comma between two ranges that don't actually intersect — check the range references for a stray space.
Still not fixed? Send us the details and we'll help you dig further, or browse related guides in Excel Errors & Fixes.

Frequently Asked Questions

Do different error codes like #REF! and #VALUE! mean different things?
Yes, each one points to a specific type of problem — #REF! means a cell reference is broken (often from deleting a row or column), while #VALUE! usually means a formula is trying to do math with text instead of a number.
Can I just hide the error message instead of fixing it?
You can wrap a formula in IFERROR to display something else instead of the error, but that hides the symptom rather than fixing the underlying cause — worth doing only once you understand why the error is happening.

Related guides

Excel Won't Open At All

Double-clicking a spreadsheet or the Excel icon does nothing, or Excel opens then immediately closes.

Beginner

Excel File Is Corrupted or Unreadable

"Excel found unreadable content" or the file simply won't open and shows a corruption warning.

Intermediate

Formulas Not Recalculating Automatically

You change a cell but the formulas depending on it don't update until you do something else.

Beginner