Function
=IF(logical_test, value_if_true, value_if_false)

3 Parameters

• logical_test = Any value or expression that can be evaluated to TRUE or FALSE. (e.g. cell A1>10)
• value_if_true = The value (or formula) that you want to be returned (or calculated) if the logical_test argument evaluates to TRUE.
• value_if_false = The value (or formula) that you want to be returned (or calculated) if the logical_test argument evaluates to FALSE.