Purpose: The IIf() function allows the conditional return of different values depending upon whether an expression evaluates to true or false.
Usage: IIf(expression, true_value, false_value)
Expression is the expression you wish to evaluate.
True_value is the value that should be returned if expression is true.
False_value is the value that should be returned if expression is false.
Returns: true_value or false_value.
Examples and Special Cases
IIf(Weight > 200, "Overweight", "Normal")
Returns "Overweight" for any weight value greater than 200 pounds and "Normal" otherwise.
