By Ken Bluttman

Part of Excel Formulas and Functions For Dummies Cheat Sheet

If you create a formula in Excel that contains an error or circular reference, Excel lets you know about it with an error message. A handful of errors can appear in a cell when a formula or function in Excel cannot be resolved. Knowing their meaning helps correct the problem.

Error Meaning
#DIV/0! Trying to divide by 0
#N/A! A formula or a function inside a formula cannot find the
referenced data
#NAME? Text in the formula is not recognized
#NULL! A space was used in formulas that reference multiple ranges; a
comma separates range references
#NUM! A formula has invalid numeric data for the type of
#REF! A reference is invalid
#VALUE! The wrong type of operand or function argument is used