Type alias FormulaErrorCode

FormulaErrorCode: "#ERROR!" | "#NAME?" | "#VALUE!" | "#DIV/0!" | "#NUM!" | "#CIRC!" | "#REF!" | "#N/A"

The error codes of a formula – like in a spreadsheet:

Code Meaning
#ERROR! syntax error (the whole column shows it)
#NAME? unknown field or function
#VALUE! wrong type, e.g. "abc" * 2
#DIV/0! division by zero
#NUM! the result is not a finite number (SQRT(-1), overflow)
#CIRC! circular reference between calculated columns (cell formulas: between cells)
#REF! cell formulas: a reference to a deleted or non-existing cell (since 1.1.99)
#N/A cell formulas: a lookup found nothing, NA() (since 1.1.99)

Since

1.1.95