| 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. | - |
Formulas
Formula error codes
When a formula is invalid or can’t be computed for the current row, an error code shows in the cell.
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: