IIF (In-line If) Function

Defines a conditional expression, as well as the expressions to execute depending on the outcome of the conditional expression.

IIF(ConditionalExpr, ExprIfTrue, ExprIfFalse)

位置 :

• ConditionalExpr is an expression that evaluates to True or False.

• ExprIfTrue is an expression to be executed if CondiionalExpr evaluates to True.

• ExprIfFalse is an expression to be executed if CondiionalExpr evaluates to False.

Only one of the two expressions (ExprIfTrue or ExprIfFalse) will get executed each time the IIF function is executed. 其中的每个表达式都可以是任何有效的单行表达式，包括其他（“嵌套的”）IIF 函数。

For more detailed information on IIF function, refer to Using the In-line If (IIF) Function.