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!
Solved! Go to 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
Thank you!