The function tests a condition and returns one of two values; the function returns the first value if the condition is true and the second value if the condition is false.

IIF

Explanation:

In database programming (Access MySql, Sql server etc) the IIF function which has the syntax IIF(condition, value_if_true, value_if_false). Will return one of the value_if_true if the condition is true or value_if_false if the condition is false.

So generally, this function when called will be passed three arguments . It checks the first argument (a boolean condition) and returns the second argument if the (boolean condition) first argument is true; else, it returns the third argument if the boolean condtion (first argument).

uiy

explanation: