Add a calculated column

If you want to add a column where all cells contain the same formula to a table, create a calculated column. You can use any column in the table that does not contain data to create a calculated column.

To convert a column to a calculated one, enter the desired formula in any cell in that column and press  Enter.

All cells in the column will automatically be filled with the formula you entered.

The following rules apply to the calculated columns:

•If you edit a formula in any cell of a calculated column, the same formula editing is automatically performed in the remaining cells of that column.

•If the data in a column is partially deleted or regular data is entered instead of a formula, the column ceases to be calculated (formula changes cease to apply to the whole column).

•If the column consistency is restored manually (all cells contain the same formula again), the column becomes calculated again.