Error

Cause

#ARRAY_FORMULA!

Formula One read in a file that contained an array formula. Since this feature is not supported in Formula One, this error value is placed in the cell which used to contain the array formula.

#DIV/0!

Divide by zero. May be caused by a reference to a blank cell or a cell containing zero.

#N/A

No value is available. May be caused by inappropriate values in the formula or a reference to a cell containing the #N/A value.

#NAME•

Name is not recognized. May be caused by a user-defined name that is not defined.

#NULL!

Null intersection. An intersection of two ranges was defined that does not intersect.

#NUM!

Number problem. May be caused by inappropriate numbers in functions, an iteration that cannot solve for a value, or a formula that results in a number too large or too small to represent.

#REF!

Reference error. May be caused by referring to a cell that was deleted.

#VALUE!

Wrong argument type. May be caused by entering text where a number was expected, or supplying a range to an operator or function that was expecting a single value.