Function: IIF

IIF (Value-to-test, Result-if-True, Result-if-false)

Arguments

1. A logical value (true or false)
2. The result to return if Arg. 1 is true
3. The result to return if Arg. 1 is false

Result

Either argument 1 or argument 2

---

This function is known as Imediate IF, and seems too simple to be useful, but it is. For example, the function IIF(Seniority-in-years> >= 5, 3, 2) could be used to determine the number of weeks of vacation the employee is entitled to.