Minitab includes several operators for formulas.

The Formula dialog box includes the following arithmetic and general operators.

Operator | What the operator does |
---|---|

+ | Add |

- | Subtract |

* | Multiply |

/ | Divide |

^ | Exponentiate |

[ ] | Specify a subscript |

( ) | Combine operations |

In the following worksheet, the values in C2 and C3 are the results of the formulas that are shown in their column name cells. Both formulas use the exponentiation operator (^) to raise the value in each row of column C1 to the power of 3. The subscript notation in the second formula (C1[2]) tells Minitab to use the value from row 2 of column C1.

C1 | C2 | C3 |
---|---|---|

C1^3 | C1^C1[2] | |

2 | 8 | 8 |

3 | 27 | 27 |

0 | 0 | 0 |

The Formula dialog box includes the following comparison operators and logical operators. If a comparison or logical test is true, the results is 1. If a comparison or logical test is false, the result is 0.

Operator | Syntax | Result is 1 (true) if |
---|---|---|

= | A = B | A is equal to B |

≠ | A <> B | A is not equal to B |

< | A < B | A is less than B |

> | A > B | A is greater than B |

< |
A <= B | A is less than or equal to B |

> |
A >= B | A is greater than or equal to B |

And | A And B | A and B are both true |

Or | A Or B | Either A or B is true |

Not | Not A | A is false |

For the following examples, refer to this worksheet that contains one row of data.

C1 | C2 |
---|---|

9 | 9 |

Formula | Result | Explanation |
---|---|---|

C1 = 5 | 0 | The value in C1 does not equal 5, so the result is false. |

C2 = 9 | 1 | The value in C2 is equal to 9, so the result is true. |

C3 > 9 | 0 | The value in C2 is not greater than 9, so the result is false. |

C1=5 And C2=9 | 0 | The expression C1 = 5 is true. The expression C2 = 9 is false. Because at least one of the expressions is false, the result of the And operation is false. |

C1=5 Or C2=9 | 1 | The expression C1 = 5 is true. The expression C2 = 9 is false. Because at least one of the expressions is true, the result of the Or operation is true. |

Not (C1 = 5) | 1 | The expression, C1 = 5, is false. Because this expression is false, the result of the Not operation is true. |

Not (C2 = 9) | 0 | The expression, C2 = 9, is true. Because this expression is true, the result of the Not operation is false. |

Not C1 | 0 | When used in a formula, any numeric value other than 0 is interpreted as true. The value in C1 is 9, which is interpreted as true. Thus, the result of the Not operation is false. |

Minitab performs operations by rows. Operations of equal order are processed from left to right. By default, operations are processed in the following order. Use parentheses to change the order of operations for a formula.

- Subscripts
- Column operations
- Functions
- Exponentiation
- "Not" and negative (-) operations
- Multiplication and division
- Addition and subtraction
- Comparison operations
- "And" operations
- "Or" operations

The following examples illustrate the default order of operations and how to use parentheses to change the order of operations.

Formula | Result | Order of operations |
---|---|---|

10 / 5 * 3 | 6 | Divide 10 by 5, then multiply the result by 3. |

10 / (5 * 3) | 0.67 | Multiply 5 by 3, then divide 10 by the result. |

6 + 2 / 4 | 6.5 | Divide 2 by 4, then add the result to 6. |

(6 + 2) / 4 | 2 | Add 6 and 2, then divide the result by 4. |