Operators for formulas

Minitab includes several operators for formulas.

Arithmetic operators and general operators

The Formula dialog box includes the following arithmetic and general operators.
Operator What the operator does
- Subtract
* Multiply
/ Divide
^ Exponentiate
[ ] Specify a subscript
( ) Combine operations

Examples

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) tells Minitab to use the value from row 2 of column C1.

C1 C2 C3
C1^3 C1^C1
2 8 8
3 27 27
0 0 0

Comparison operators and logical operators

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

Examples

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.

Order of operations

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.
1. Subscripts
2. Column operations
3. Functions
4. Exponentiation
5. "Not" and negative (-) operations
6. Multiplication and division
7. Addition and subtraction
8. Comparison operations
9. "And" operations
10. "Or" operations

Examples

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.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy