Multiple If statement with conditions help

[cfine]

I am trying to write a formula to take care of the following formula I had in excel:

IF([column1]="5403",(IF([column2]>0,1,2)),0)

Thanks for the help!

[cplewis90 · Accepted solution]

Hey @cfine,

To write this in Alteryx you would set it up this way:

If [column1] = "5403"

then if [column2] > 0

        then 1

        else 2

        endif

else 0

endif

[cfine]

Thank you!