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 

 

Keywords

iif formula if then else case statement