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 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