community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Nested IF THEN Statement

Asteroid

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

Pulsar
Pulsar

@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. 

Highlighted
Asteroid

This worked perfectly!! Thanks so much!

Labels