IF Function
Purpose
Evaluates a logical condition and returns one value if TRUE, and another value if FALSE.
Syntax
EXCEL
=IF(logical_test, value_if_true, [value_if_false])
Evaluates a logical condition and returns one value if TRUE, and another value if FALSE.
=IF(logical_test, value_if_true, [value_if_false])