Monday, April 16, 2012

Excel Error Codes


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

No comments:

Post a Comment

[Valid Atom 1.0]