Excel Error Messages to Get to Know

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.



































ErrorMeaning
#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
operation
#REF!A reference is invalid
#VALUE!The wrong type of operand or function argument is used



dummies

Source:http://www.dummies.com/how-to/content/excels-error-messages.html

No comments:

Post a Comment