SeaTable offers you many different functions that you can add to your table. One of them is the so-called **formula column**. Using formulas you can link values from different columns and create different functions based on the data types of these columns.

Among other things, you can calculate with values in a row , merge them or relate them to each other.

**not**possible. A formula can only work with the

**values from the same row**.

## Create a formula column

To apply a formula, you must first add a new formula column to your table. You can learn how to do that here.

SeaTable provides you with a **formula editor** to help you enter formulas.

## Write a first formula

Once your formula column is created, you can start writing the formula. The following figure shows a simple formula to calculate the average of five numbers.

This formula always writes the static value *13.2* into the formula column as the result. However, the true power of the formula column only comes into its own when you use the values of other columns for your formula. With the **{column name}** in curly brackets you can reference existing columns in your table.

**Double click**must be inserted into the formula.

Then you can insert certain **constants**, **operands** and **functions** into your formula to calculate with, merge or relate the values of the different columns.

## Clear color language

To be able to distinguish the different elements of your formula from each other, they are marked in a different **color** depending on their type:

Object | Example |
---|---|

Functions | |

Text / String | |

Numbers | |

Column references |

## Formula examples

Below are a few examples that illustrate the utility and use of formulas.

- Formula example: Simple multiplication with a formula
- Formula example: Merging text columns using a formula
- Formula example: Logical if operators for comparing values
- Formula example: Calculate the duration of a vacation
- Formula example: Calculate days until an event
- Formula example: Search for a word in a text

## Mathematical conventions also apply in SeaTable

Of course you can rely on the fact that mathematical conventions also find their application in the formulas of SeaTable. Here are the most important examples:

- You can
**nest****functions**within each other using parentheses. Example: (( 1 + 2 ) * 3) **Dot before dash**, the**order of parentheses**and other**mathematical rules**are taken into account in SeaTable.

## Formula column formatting

You can format the results in the formula column. Each formula in SeaTable has a **number**, a **date** or a **text/string** as result. Therefore, depending on this, you have different **format settings** available.