To create an inline IF statement (akin to the tertiary operator "? :" we're all used to)
You must follow this syntax
xxxxxxxxxx
Dim example as String
example = IIF(<expression>, TRUE, FALSE)
to remember it, IIF stands for "INLINE IF"
xxxxxxxxxx
If condition_1 Then
result_1
ElseIf condition_2 Then
result_2
ElseIf condition_n Then
result_n
Else
result_else
End If