IIf (function)

Syntax IIf (condition,TrueExpression,FalseExpression)
Description Returns TrueExpression if condition is True ; otherwise, returns FalseExpression.
Comments Both expressions are calculated before IIf returns. The IIf function is shorthand for the following construct: 
  If condition Then
    variable = TrueExpression
  Else
    variable = FalseExpression
  End If
Example 
Sub Main() 
  s$ = "Car"
  MsgBox "You have a " & IIf(s$ = "Car","nice car.","nice non-car.")
End Sub
See Also Choose (function); Switch (function); If...Then...Else (statement); Select...Case (statement).