Returns one of two values depending on whether the condition was true or false.
Syntax
target.IIF(condition, valueTrue, valueFalse)
Parameters
condition - condition to be checked valueTrue - the value to be returned if the condition is true valueFalse - the value to be returned if the condition is false
Return value
returns valueTrue if condition is true and valueFalse if condition is false.
