Table of contents
Collapse the table of content
Expand the table of content

IIf Function

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Returns one of two parts, depending on the evaluation of an expression. SyntaxIIf( expr,truepart,falsepart ) The IIf function syntax has thesenamed arguments:

exprRequired. Expression you want to evaluate.
truepartRequired. Value or expression returned if expr is True.
falsepartRequired. Value or expression returned if expr is False.

RemarksIIf always evaluates both truepart and falsepart, even though it returns only one of them. Because of this, you should watch for undesirable side effects. For example, if evaluating falsepart results in a division by zero error, an error occurs even if expr is True.


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
© 2018 Microsoft