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)