Nested IF THEN Statement

grsomer

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!!

Kenda

@grsomer 

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.