iif()
Inline if function
iif(expression, true_part, false_part = nothing)
expression (boolean) — An expression to be evaluatedtrue_part (any) — A valuefalse_part (any, optional) — A value. The default value is nothing
any — Returns true_part if the expression is true, returns false_part if otherwise
iif(10 > 5, 20, 30) ' Returns 20
iif(20 > 100, "OK") ' Returns nothing