Cell error indicators

If Ability cannot perform the calculation you request in a formula, it displays an error indicator in the cell instead of the result of the calculation.

There are five different error messages:

Error

Explanation

#VALUE

Formula cannot be evaluated. For example, the type of an argument does not match, as in SQRT(-16), or an argument is out of range, as in RIGHT("New York", -5).

#FUNC

Wrong number of function arguments or improper function argument. For example, SIN(A1, A2, A3) or COS(A1..B10).

#DIV0

The formula attempts to divide by zero.

#REF

Bad reference argument in formula. For example, SUM(Sales), when there is no range called Sales.

#CIRC

The formula makes a circular link. For example, when the formula =A1 + 5 is entered in A1.

See also:

Function reference