IIf function
Summary
Immediate If.
Syntax
IIf(expr, truepart, falsepart)
The IIf function syntax has these named arguments:
Part
Description
exprRequired. Expression that you want to evaluate.
truepartRequired. Value or expression returned if expr is True.
falsepartRequired. Value or expression returned if expr is False.
Part
Description
exprRequired. Expression that you want to evaluate.
truepartRequired. Value or expression returned if expr is True.
falsepartRequired. Value or expression returned if expr is False.
Example
Example
This example uses the IIf function to evaluate the TestMe parameter of the CheckIt procedure and returns the word "Large" if the amount is greater than 1000; otherwise, it returns the word "Small".
Function CheckIt (TestMe As Integer)
CheckIt = IIf(TestMe > 1000, "Large", "Small")
End Function
This example uses the IIf function to evaluate the TestMe parameter of the CheckIt procedure and returns the word "Large" if the amount is greater than 1000; otherwise, it returns the word "Small".
Function CheckIt (TestMe As Integer)
CheckIt = IIf(TestMe > 1000, "Large", "Small")
End Function