Formula error codes

When a formula is invalid or can’t be computed for the current row, an error code shows in the cell. Common AI Table error codes:

Error code	Meaning	Example
#NULL!	Null error. The formula contains an invalid range operator or specifies two ranges that don’t intersect.
#DIV/0!	Divide-by-zero error. Division where the divisor is zero or references an empty cell.	`2/0`
#REF!	Invalid reference error. A referenced column was deleted or changed.
#N/A	Value-not-available error. A value isn’t available to the function — lookup found nothing.	`REGEXEXTRACT("def","a")`
#VALUE!	Value error. Wrong argument or operand type — e.g., text where a number is expected.	`SQRT("test")`
#ERROR!	Formula parse error. Malformed formula.	`test formula`
#NUM!	Number error. Invalid numeric value, or a result too large or small to display — e.g., square root of a negative.	`SQRT(-1)`
#NAME?	Invalid name error. Unrecognized text in the formula — typo in function or name.	`SUMMM()`
#TOO\_LARGE!	Result-too-large error. Result exceeds 200 items — e.g., a lookup returning more than 200 values.
#MISMATCH\_TYPE!	Type mismatch error. Result type doesn’t match the column type — common after the original value is changed.
#CIRCULAR!	Circular reference error. The formula refers, directly or indirectly, to its own cell.
#UNSUPPORT!	Unsupported-feature error. A function or feature in the formula isn’t supported yet — e.g., cross-table references.	-

More formula FAQs