> ## 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 formula fields

> A formula field is a field type in AI Table — use rich function expressions for flexible data calculations.

A formula field is a field type in AI Table — use rich function expressions for flexible data calculations.

## Create a formula field

Click the **+** icon to the right of the AI Table header bar, pick **Formula** as the field type.

![](https://img.alicdn.com/imgextra/i1/O1CN01Qkznx71eXYH9gb8Uf_!!6000000003881-2-tps-1032-474.png)

## Edit formula

Click **Edit formula** — the formula editor opens.

![](https://img.alicdn.com/imgextra/i4/O1CN01GpkxPA1Dy7cv6C9jX_!!6000000000284-2-tps-628-433.png)

Edit the formula directly in the top input box.

In the **Formula edit** tab, reference fields or pick functions by category.

In the **AI generate formula** tab, generate a formula from natural language — details: [Generate formulas with AI](/aitable/formulas/ai-generate-formula).

![](https://img.alicdn.com/imgextra/i2/O1CN01Rgi2P71ulK2HVJLKi_!!6000000006077-2-tps-1080-936.png)

## Concepts

| Term               | Meaning                                                                    |
| ------------------ | -------------------------------------------------------------------------- |
| Field              | The value of a column at a given row, used in formula computation          |
| Whole-column field | The collection of values for an entire column, used in formula computation |
| Brackets           | Used in formulas to reference AI Table tables or fields                    |
| Operator           | Logical or arithmetic symbol used in a formula                             |
| Function           | Produces an expected output via a specific computation rule                |
| Argument           | Number or text that participates in formula computation                    |
| String             | A sequence of text used in formula computation                             |
| Array              | A collection of values                                                     |

## Common operators

| Type        | Operator | Meaning                                                              |    |
| ----------- | -------- | -------------------------------------------------------------------- | -- |
| Arithmetic  | `+`      | Add two values                                                       |    |
|             | `-`      | Subtract two values                                                  |    |
|             | `*`      | Multiply two values                                                  |    |
|             | `/`      | Divide two values                                                    |    |
| Text concat | `&`      | Concatenate two strings; concat number with text when one is numeric |    |
| Logical     | `>`      | Greater than                                                         |    |
|             | `>=`     | Greater than or equal                                                |    |
|             | `<`      | Less than                                                            |    |
|             | `<=`     | Less than or equal                                                   |    |
|             | `=`      | Equal                                                                |    |
|             | `!=`     | Not equal                                                            |    |
|             | `&&`     | AND                                                                  |    |
|             | \`       | \`                                                                   | OR |

## Read more

[Formula function reference](/aitable/formulas/function-reference)

[Generate formulas with AI](/aitable/formulas/ai-generate-formula)

## FAQ

[Formula FAQ](/aitable/formulas/formula-faq)

[Formula error codes](/aitable/formulas/error-codes)