IIF

Selects between the second and third arguments based on the condition.

Category: Utility Functions

Syntax

IIF(condition, true_value, false_value)

Arguments

• condition boolean Boolean expression used to choose which result to return.
• true_value any Value returned when condition evaluates to true.
• false_value any Value returned when condition evaluates to false.

Returns

same as true_value — Returns a value with the same type as true_value.