If condition1 is true, returns result1, otherwise returns else-result.
You can include additional condition/result pairs before the final else-result (as in the first example). QuickBase evaluates the conditions in sequence until one is found to be true, and then the corresponding result is returned.
The else-result is optional. If omitted, QuickBase assumes it's null (or empty - a blank).
All conditions must be of type Boolean (return a true or a false). Results may be of any type, but they must all be the same type.