Question: what is the difference between if and iif?
Answer: The IF() function is a simple version of the IIF() function. The key difference between the two is the IIF() function provides users an option to return a specific value in the event the test expression doesn't return either TRUE or FALSE, i.e. is null or unknown. ... IIF(test, then, else) IIF(test, then, else, unknown)