Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Multiple If statement with conditions help

cfine
7 - Meteor

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!

 

 

2 REPLIES 2
cplewis90
13 - Pulsar
13 - Pulsar

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

Thank you!

Labels