IF function

description:

This function returns the second argument if the condition is met, otherwise returns the third argument.

 

syntax:

=IF( logical_test[value_if_true][value_if_false] )

 

required arguments:

logical_test Condition.

 

optional arguments:

[value_if_true] This value is returned when the condition is met.
[value_if_false] This value is returned when the condition is not met.