Formulas let you define data in a column as a function of data in other 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.

Columns with formulas have a green checkmark in the column number cell.

To assign a formula to a column, click in the column, choose , then enter the expression. For more information, go to Create a formula with the Calculator.

To prevent formula results from updating automatically when data change, choose to deselect it.

Suppose you have data in C1 and C2. You want to calculate the sum of these two columns in C3, and the product of the two columns in C4. You want Minitab to automatically recalculate C3 and C4 whenever the data change in either C1 or C2.

- Click in C3. Choose .
- In Expression, type
`C1+C2`. Click OK. - Click C4. Choose .
- In Expression, type
`C1*C2`. Click OK. - Verify that is selected.

To view the formula for a column, hold the pointer over the formula icon in the column number cell. To view all the formulas in the worksheet, follow these steps.

- Choose .
- Type
`info`, then click Submit Commands.

The information is displayed in the Session window.

You can control when formulas in a project are calculated.

If formulas are not set to calculate automatically and the data in the formula change, the icon in the column number cell changes to a yellow triangle.

- Click in the worksheet, then choose to deselect it.
- To calculate all formulas in the project one time, choose . If this option is grayed out, all formulas are up to date.

To change the default settings for future sessions of Minitab, choose .

- Select the column or columns that contain the formulas to delete.
- Choose .