IF

Depending on the outcome of a condition test, returns one of two expressions.

Return Value

Can vary

Syntax

IF( condition, trueExpr, falseExpr )

where:

• condition is the condition to be tested for.
• trueExpr is the expression to be returned if the condition tests TRUE.
• falseExpr is the expression to be returned if the condition tests FALSE.