To add a column to the table with the same formula in all cells:
1.Select any empty column in the table.
2.Type the desired formula in any cell in that column and press Enter.
The formula will automatically propagate to all cells in the column.
Features of a calculated column
–When you edit a formula in any cell of a column, the changes are automatically applied to the entire column.
–If you enter data (not a formula) in some cells or delete some formulas, the column is no longer computable.
–To restore a calculated column, make sure that all of its cells contain the same formula.