O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required