IIF function without ()

Error 2440

The IIF function requires parenthesis around its arguments (as shown below).

IIf( expr, truepart, falsepart )

The IIf function has the following parts:

 

Argument

Description

expr

Expression you want to evaluate.

truepart

Value or expression returned if expr is True.

falsepart

Value or expression returned if expr is False.