Skip to main content

IFF

IFF(expression, trueresult [, falseresult ])

expressionA conditional expression.
trueresultThe result to return when the expression is true. This may be any expression or action.
falseresultThe result to return when the expression is false. This may be any expression or action. This may be omitted only if the result is an action.
Return:IF returns a single value, set, recordset, or action.

The IFF function performs the same functionality as IF, but ensures that an expression containing complex boolean logic is evaluated exactly as it appears.

See Also: IF, MAP, EVALUATE, CASE, CHOOSE, SET