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 does not fit in the column, i.e., the column must be wider for the number to be shown |
#N/A | value cannot be computed, e.g., 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, e.g., square root of a negative number |
#OVERFLOW | value is too large for the worksheet (largest absolute value is about 1.797E+308) |
1.#INF | value is too large for the worksheet, i.e., "infinite" value surpassed |
1.#IND | numeric value is indefinite (usually the result of performing a calculation with an infinite value or attempting to divide by zero) |