The IIF statement is the same as an IF statement. The first parameter is the conditional statement. The second parameter is the return value if the condition is met. The third parameter is the value returned if the condition is not met.

The IIF statement has many uses.

- To show or hide data based on a condition.

- To show a default value if a field is null or empty.

- It can be used in a formula to give every other row a background color.

- etc.