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.