Hi!
I am trying to recreate an excel formula in ALteryx. The formula is: "=IF(F2=""Sell""," & _
"IF(AX2=""FEES_BBL_ACCR"",""1800"",""1300"")," & _
"IF(AX2=""FEES_BBL_ACCR"",""2800"",""2300""))")
I believe the statement is saying: If column F equals "Sell" and column AX equals "FEES_BBL_ACCR", then 1800, else 1300. And if F2 does not equal "Sell" and column AX equals "FEES_BBL_ACCR", then 2800, else 2300.
Is there a way to recreate this in Alteryx?
Thanks!!
Solved! Go to Solution.
Try this:
if [Field1]="Sell" then (if [Field2]="FEES_BBL_ACCR" then 1800 else 1300 endif) else (if [Field2]="FEES_BBL_ACCR" then 2800 else 2300 endif) endif
Where Field1 is your column F2 and Field2 is your column AX.
This worked perfectly!! Thanks so much!