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

​
Syntax

  • 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.
Result: “Error” (5/0 raises #DIV/0!).

​
Example 2: normal computation

[Field 1] in the first record is 2.
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.