To use this function, choose .
Chooses which of two values to return based on whether a condition is true or false.
IF(test,value_if_true,[value_if_false])
For test, specify the condition, and for value_if_true, specify the value to return if the condition is true. Conditions can be any numerical or logical expressions. The third argument, value_if_false, is optional and lets you specify a value to return if the condition is false. If you don't specify value_if_false, Minitab returns a missing value.
To change a column of 0's and 1's to "male" and "female", enter the expression IF(C1=1,"male","female") and store the results in C2.
C1 | C2-T |
---|---|
0 | female |
1 | male |
0 | female |
1 | male |
0 | female |