AgileApps Support Wiki Pre Release

IF

From AgileApps Support Wiki

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'