IF

The IF function evaluates a logical argument. If the first parameter is true, this function returns the second parameter. If the first parameter is false, this function returns the third parameter.

Syntax

IF(logical_test, value_if_true, value_if_false)

Return

Text string

Example

IF(TRUE,'The test is true', 'The test is false') = 'The test is true'
IF(FALSE,'The test is true', 'The test is false') = 'The test is false'