Formulas in columns

Formulas let you define data in a column as a function of data in other columns.

For example, if you record length in a column named L, and width in a column named W, you can use the formula W * L to automatically calculate the area and store it in a third column (named Area). When values in L or W change, the Area column is automatically updated.

You assign a formula to an entire column, not to individual cells. A formula assigned to a column cannot reference that same column directly or indirectly. For example, you cannot assign the formula 2 * C1 to column C1 because each data value in C1 cannot simultaneously be its original value and twice its original value.