If / IIf

Value = If ( Boolean , True value [ , False value ] )

Evaluate the Boolean expression, and return True value if this expression is true, or False value if this expression is false.

If False value is not specified, it is assumed to be NULL .

Be careful : Contrary to IF, both True value and False value are evaluated, whatever the value of Boolean is.

Example :

X = 7

PRINT If((X MOD 2) = 1, "Impair", "Pair")
=> Impair

PRINT If((X MOD 2) = 1, "Impair", 1 / 0)
** Division by zero **


Referenced by :