Assign a formula to a column

Formulas let you define data in a column as a function of data in other columns. For example, if you record the length (L) in one column and width (W) in a different column, you can use the formula W * L to automatically calculate the area and store the product in a third column.

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

  1. Click in C3. Choose Editor > Formulas > Assign Formula To Column.
  2. In Expression, type C1+C2. Click OK.
  3. Click in C4. Choose Editor > Formulas > Assign Formula To Column.
  4. In Expression, type C1*C2. Click OK.
  5. Verify that Editor > Formulas > Calculate All Formulas Automatically is selected.
  6. To view a list of all the formulas assigned to columns in the worksheet, do the following:
    1. With the Session window active, choose Edit > Command Line Editor.
    2. Type info.
    3. Click Submit Commands.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy