IF ELSE - Multiple conditions

sriniprad08

Hi Team,

Hope you are well I need help.

I am trying to create a new column based on the single column with multiple categories.

Not sure what ia m missing.

Please find attached the workflow and output.

its giving error for zzTrade. I have a condtions like below please

Thanks

IF [Instrument]= "('zzAdvance' or 'zzTrade' or 'zzCollect' or 'zzProject Financing')"
THEN "CTTS"
ELSEIF "('xlcAdvance' or 'xlcTrade')" THEN "cxl"

ELSE "Error"

ENDIF

binu_acs

@sriniprad08 If you use the OR statement you should also mention the field name , which was missing in your if statement

IF [Instrument] = "zzAdvance" OR [Instrument] = "zzTrade" Then "CTTS"
ELSE "ERROR"
ENDIF

try the below formula

IF [Instrument] IN('zzAdvance' , 'zzTrade' , 'zzCollect' , 'zzProject Financing')
THEN "CTTS"
ELSEIF [Instrument] IN ('xlcAdvance' , 'xlcTrade') THEN "cxl"

ELSE "Error"

ENDIF