Worksheet Error Codes and Special Numeric Values
There are a few different error codes and special numeric values that can appear in a worksheet cell depending on the type and nature of the data that appears.
|
Codes |
Explanation |
|
######### |
number will not fit in the column - the column must be wider for the number to be shown |
|
#N/A |
value cannot be computed (for example, not enough data to calculate a statistic) |
|
#DIV/0! |
an attempt to divide-by-zero was made in performing a calculation |
|
#ERROR |
a value could not be computed (for example, square root of a negative number) |
|
#OVERFLOW |
the value is too large for the worksheet (largest absolute value is about 1.797E+308) |
|
1.#INF |
the value is too large for the worksheet (i.e., "infinite" value) |
|
1.#IND |
numeric value is indefinite (usually the result of performing a calculation with an infinite value or attempting to divide by zero) |