Convert Excel formulas to Alteryx

[mylar]

Hi there,

Could someone help me to convert the following excel formulas to Alteryx language, please?

I don't know how to use function "or" and "search"

=IF(SO Unshpble Rsn<>"",IF(ISNUMBER(SEARCH("CC",SO Unshpble Rsn)),Zona&"Dates",IF(ISNUMBER(SEARCH("Cx",SO Unshpble Rsn)),Zona&"Dates",IF(ISNUMBER(SEARCH("CR",SO Unshpble Rsn)),Zona&"Credit",IF(ISNUMBER(SEARCH("DH",SO Unshpble Rsn)),Zona&"HBlock",IF(ISNUMBER(SEARCH("DL",SO Unshpble Rsn)),Zona&"LBlock",IF(ISNUMBER(SEARCH("MS",SO Unshpble Rsn)),Zona&"Duplicate Size",IF(ISNUMBER(SEARCH("AC",SO Unshpble Rsn)),Zona&"Aging Contract",IF(ISNUMBER(SEARCH("IN",SO Unshpble Rsn)),Zona&"Incomplete","")))))))),"")

And:

=IF(Rsv+Fix>0,IF(Credit Stat="B","Credit",IF((Block&Line)<>"","Block",IF(OR(Launch ID="C",Launch ID="D",Launch ID="L"),"Initiative","Free"))),"")

Thanks!

[Luke_C]

Hi @mylar 

Are you able to provide any sample data? These are complex formulas so having data to test them on will be helpful.