target.IIF

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.