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.