#####
|
The numeric value is too wide to
display within the cell. You can re-size the column by dragging the boundary
line between the column headings.
|
#VALUE!
|
You entered a mathematical
formula that references a text entry instead of a numerical entry.
|
#DIV/0!
|
You tried to divide a number by
zero. This error often occurs when you create a formula that refers to a
blank cell as a divisor.
|
#NAME?
|
You entered text in a formula
that Excel doesn't recognize. You may have misspelled the name or function,
or typed a deleted name. You also may have entered text in a formula without
enclosing the text in double quotation marks.
|
#N/A
|
This error occurs when a value is
not available to a function or a formula. If certain cells on your worksheet
contain data that is not yet available, enter #N/A in those cells. Formulas
that refer to those cells will then return #N/A instead of attempting to
calculate a value.
|
#REF!
|
The #REF! error value occurs when
a cell reference is not valid. You probably deleted a cell range that is
referenced in a formula.
|
#NUM!
|
The #NUM! error value occurs when
you use an invalid argument in a worksheet function.
|
#NULL!
|
You specified an intersection of
two ranges in a formula that do not intersect.
|
Monday, April 16, 2012
Excel Error Codes
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment