> ## Documentation Index
> Fetch the complete documentation index at: https://help.dingtalk.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Using IFERROR

> 📌 More functions: see the formula function reference.

> 📌 More functions: see the [Formula function reference](/aitable/formulas/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**

| Error   | Meaning                                               |
| ------- | ----------------------------------------------------- |
| #N/A    | Missing 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

```text theme={"theme":{"light":"github-light","dark":"github-dark"}}
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**.

```text theme={"theme":{"light":"github-light","dark":"github-dark"}}
=IFERROR(5/[Field 1], "Error")
```

Result: **"Error"** (5/0 raises **#DIV/0!**).

#### Example 2: normal computation

\[Field 1] in the first record is **2**.

```text theme={"theme":{"light":"github-light","dark":"github-dark"}}
=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.

```text theme={"theme":{"light":"github-light","dark":"github-dark"}}
IFERROR(FIND("Allergen",[Product description],1),"Missing allergen note ❌")
```