Understanding Error Values
An error value is the result of a formula that Excel can't resolve. The seven error values are described in Table 12-2.
Table 12-2. Error Values
Error Value | Cause |
|---|---|
#DIV/0! | You attempted to divide a number by zero. This error usually occurs when you create a formula with a divisor that refers to a blank cell. |
#NAME? | You entered a name in a formula that isn't in the Define Name dialog box list. You might have mistyped the name or typed a deleted name. Excel also displays this error value if you do not enclose a text string in quotation marks. |
#VALUE | You entered a mathematical formula that refers to a text entry. |
#REF! | You deleted a range of cells whose references are included in a formula. |
#N/A | No information is available for the calculation ... |
Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
