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)