AgileApps Support Wiki Pre Release

IF

From AgileApps Support Wiki
Revision as of 22:15, 25 August 2009 by imported>Evelyn
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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'