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).

I