Case() is a variation of the If() function. If you want to test many conditions against a single field, use the Case() function instead of the If() function.
QuickBase evaluates the value x and compares it to each of the values that follow (val1 and so on) sequentially. If the value X matches any value, QuickBase returns the corresponding result which lives behind the comma following the matched value. If value x is not equal to any of the values, QuickBase returns the else-result at the end of the formula.
The else-result is optional. If omitted, QuickBase assumes it's null (empty).
The value x may be of any data type, but all of the values must be of the same type as x.