Returns one of two values depending on whether the condition was true or false.Â
target.IIF(condition, valueTrue, valueFalse)
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
returns valueTrue if condition is true and valueFalse if condition is false.
See also