IF function

Description IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE. Syntax IF(logical_test, [value_if_true], [value_if_false]) Parameters logical_test: Required. Any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if…