IIF

An if-then statement with capability of returning a third, unique value if condition is null

IF( condition, then, else, when null)

Tests condition and returns then if condition is true, else if condition if false, and a when null value if null.

Arguments

Argument	Description
condition	Boolean expression to test
then	What to return if true
else	What to return if false
when null	What to return if condition is unknown

Output

Outputs then if condition is true, else if condition is false, and a when null value if condition is null.

Example