Tips and Tricks - Applies to Infiniti v8.0 or later


Often, it is necessary to nest iif() functions to cater to scenarios where there are several possible input values.

For example, in the formula below, the [q1] reference has three possible values namely 1, 2,and 3 and resolves to the phrase Plane, Train or Automobile.

iif(isequal([q1],1),"Plane",iif(isequal([q1],2),"Train", "Automobile"))


Related Articles

iif function 



iif formula if then else case statement