The IIf statement is a shorthand type of If..Then..Else statement. It evaluates a conditional expression then returns one value if the expression is true, and a different value if the expression is false. The syntax of the IIF statement is as follows:
IIF(<conditional expression>,<TRUE return value>,<FALSE return value>)
Here are examples for finding the maximum and minimum of two numbers. Since VBA has no built-in min or max functions these examples may find their way into many of your VBA applications.
dMax = IIf(dValue1 > dValue2, dValue1, dValue2)
dMin = IIf(dValue1 < dValue2, dValue1, dValue2)
The above IIF statements give the same result as the following If…Then…Else statements.
If (dValue1 > dValue2) Then
dMax = dValue1
dMax = dValue2
If (dValue1 < dValue2) Then
dMin = dValue1
dMin = dValue2