# Formulas

- Human documentation: [https://docs.univer.ai/guides/bases/features/core/formulas](https://docs.univer.ai/guides/bases/features/core/formulas)

- Agent Markdown: [https://docs.univer.ai/guides/bases/features/core/formulas.md](https://docs.univer.ai/guides/bases/features/core/formulas.md)

- Requested language: `en-US`

- Content language: `en-US`

- Documentation version: `1.0.0-rc.0`

- Source: [bases/features/core/formulas.mdx](https://github.com/dream-num/documentation/blob/dev/content/guides/bases/features/core/formulas.mdx)

---

Bases formula fields calculate record values from table data. `UniverBasesPlugin` registers its formula-engine dependency automatically.

## Register formula support

```ts
import { UniverBasesPlugin } from '@univerjs-pro/bases'
import { UniverBasesUIPlugin } from '@univerjs-pro/bases-ui'

univer.registerPlugin(UniverBasesPlugin)
univer.registerPlugin(UniverBasesUIPlugin)
```

## Create a formula field

```ts
const formulaTableName = table.getFormulaName()
const total = table.addField('Total', univerAPI.Enum.BaseFieldType.Formula, {
  field: {
    config: {
      formula: `=SUM(${formulaTableName}[[#This Row],[Price]],${formulaTableName}[[#This Row],[Tax]])`,
    },
  },
  externalReferences: [],
})
```

`externalReferences` is required for every formula-field write. Use `[]` only for formulas that reference fields in the host Base. For cross-unit formulas, use [`buildReference`](https://docs.univer.ai/reference/facade/formula.md#buildreference) and pass every stable source binding in this array.

## Notes

* Formula fields are derived values; avoid writing directly to formula cells from application code.
* Formula expressions use structured field references such as `Table[[#This Row],[Price]]`.
* Recalculate formulas after importing large snapshots before exposing results to users.