December 2019
Beginner
370 pages
8h 9m
English
IIF is similar to IF for one condition. It follows the syntax: IIF(test, then, else, [unknown]). Here, it will test a condition and if the condition is true, the statement returns the then value; otherwise, it returns the else value. If the else value is not specified, NULL will be returned, for example, IIF([Sales]>0,"Valid","Invalid").
Read now
Unlock full access