IIF (In-line If) Function

Defines a conditional expression and the expressions to run depending on the outcome of the conditional expression.

IIF(ConditionalExpr, ExprIfTrue, ExprIfFalse)

Donde:

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

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

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

Only one of the two expressions (ExprIfTrue or ExprIfFalse) are run each time the IIF function runs. Cualquiera de estas expresiones puede ser cualquier expresión válida de una sola línea, incluidas las funciones adicionales IIF ("anidadas").

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