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.