IIF

A boolean condition or value is passed into the first argument.

If the condition is true the second argument is evaluated and returned, if false the third argument is evaluated and returned.

Method Signature

IIF(condition=[boolean], expression1=[string], expression2=[string])

Argument Type Required Description Default

Argument	Type	Required	Description
`condition`	`boolean`	`true`	The condition to evaluate
`expression1`	`string`	`true`	The expression to evaluate if the condition is true
`expression2`	`string`	`true`	The expression to evaluate if the condition is false

condition

boolean

true

The condition to evaluate

expression1

string

true

The expression to evaluate if the condition is true

expression2

string

true

The expression to evaluate if the condition is false

Last updated 25 days ago