Skip to main content
๐Ÿ“Œ More functions: see the Formula function reference.

โ€‹
1 Basics

IFERROR is a common AI Table function โ€” checks if a formula or expression returns an error. If the result is an error (#DIV/0!, #VALUE!, #REF!, #NAME?, #NULL!, etc.), it returns a user-specified value; otherwise it returns the original result. Common error types
ErrorMeaning
#N/AMissing data
#VALUE!Wrong formula form or wrong value type in computation
#REF!Invalid reference โ€” e.g., references a deleted field
#DIV/0!Divisor is 0 (not allowed)
#NUM!A number in the formula is invalid
#NAME?Unrecognized content
#NULL!Wrong range operator or invalid reference

โ€‹
Syntax

IFERROR(value, [if_error])
  • value: the cell, formula, or expression to check.
  • if_error: what to return when value errors.

โ€‹
Examples

โ€‹
Example 1: handle divide-by-zero

[Field 1] in the first record is 0. 
=IFERROR(5/[Field 1], "Error")
Result: โ€œErrorโ€ (5/0 raises #DIV/0!).

โ€‹
Example 2: normal computation

[Field 1] in the first record is 2. 
=IFERROR(5/A2, "Error")
Result: 2.5 (5/2 has no error). With IFERROR, you can handle formula errors gracefully โ€” keeps the table clean and improves UX and analysis accuracy.

โ€‹
2 Scenario examples

โ€‹
2.1 Flag missing content

Per requirement, product descriptions must call out allergens โ€” use FIND to check. 
IFERROR(FIND("Allergen",[Product description],1),"Missing allergen note โŒ")