If (general) function

Syntax

IF(test,value_if_true,...,test,value_if_true,[value_if_false])

For test, specify each condition. Conditions can be any numerical or logical expressions. For value_if_true, specify the value to return if the condition is true. You can enter multiple conditions and values. All values must be the same data type (numeric or text). Minitab returns the value corresponding to the first true condition, working from left to right. The final argument, value_if_false, is optional and lets you specify a value to return if all the conditions are false. If you don't specify value_if_false, Minitab returns a missing value.