If
The If function checks the first argument and returns the second argument if the first evaluates to true. The third argument is returned on false.
Usage:
= If(<logical_test>, <true_value>, <false_value>);
Example:
= If(profits / sales > 25%, "good sales", "work to do");