IF
Syntax
=IF(logical_test; [value_if_true]; [value_if_false])
Description
Checks whether a condition is met, and returns one value if TRUE, and another if FALSE.