IIf Function

Syntax:

IIf(condexpr, TruePart, FalsePart)

Group:

Miscellaneous

Description: Returns the value of the parameter indicated by condexpr. Both TruePart and FalsePart are evaluated.

Parameters:

Parameter

Description

condexpr

If this value is True then return TruePart. Otherwise, return FalsePart.

TruePart

Return this value if condexpr is True.

FalsePart

Return this value if condexpr is False.

Example:

Sub Main
  Debug.Print IIf(1 > 0,"True","False") '"True"
End
Sub

See Also:

If, Select Case, Choose( )