Multiple IIF statements

[Corey]

I'm trying to compile a number of IIF statements.

I have 6 IIF statements, but would like to put them all in to one IIF statement.

Could anyone help me with this one?

OrderTrack: IIf([O_SRC_CD]="2005WMDT","Web","Phone")
OrderTrack: IIf([O_SRC_CD]="2005WMKE","Internet","Phone")
OrderTrack: IIf([O_SRC_CD]="DOGNET23","Web","Fax")
OrderTrack: IIf([O_SRC_CD]="CANTRY3J","Web","")
OrderTrack: IIf([O_SRC_CD]="MAMTWOSE","Web",",")
OrderTrack: IIf([O_SRC_CD]="2005W999","Web","Mail")

Thank you for your help and time

Corey

 

[KeithG]

Try this

IIf([O_SRC_CD]="2005WMDT","Web",IIF([O_SRC_CD]="2005WMKE","Internet",IIF([O_SRC_CD]="DOGNET23","Web",IIF([O_SRC_CD]="CANTRY3J","WEB",iif([O_SRC_CD]="MAMTWOSE","WEB",IIF([O_SRC_CD]="2005W99","Web","Mail"))))))

 

[pdx_man]

How do you know if something should be Fax, Phone or Mail?

Take a look at the SWITCH function.