IF Operator

The IF statement operator lets you indicate a value conditional upon the truth of another value. The IF operator has the following syntax:

variable = IF expression THEN expression ELSE expression

variable is assigned the value of the THEN expression if the IF expression is true, otherwise it is assigned the value of the ELSE expression. The IF operator is similar to the IF statement, but it can sometimes be more efficient.