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: