Hello,
I need help writing a multi nested IF statement in Alteryx based on the excel formula attached. Here is another written out version for better context:
IF(AND(OFFER DUE DATE <>1/1/1900, OFFER DUE DATE>=5/1/2023, OFFER DUE DATE<=5/31/2023),
- Value if true: IF(OR(AND(IP OFFER SUBMIT DATE<>1/1/1900, OFFER SUBMIT DATE 1 <=OFFER DUE DATE, ENTITY FEE RECEIVED 1 ="Yes"), AND(OFFER SUBMIT DATE 2 <>1/1/1900, OFFER SUBMIT DATE 2 <=OFFER DUE DATE, ENTITY FEE RECEIVED 2 ="Yes")),
- Value if true: “TRUE”,
- Value if false: IF(AND(OFFER SUBMIT DATE 1 <>1/1/1900, OFFER SUBMIT DATE 1 <=OFFER DUE DATE, ENTITY FEE RECEIVED 1 ="Yes", OFFER SUBMIT DATE 2 <>1/1/1900, OFFER SUBMIT DATE 2 <=OFFER DUE DATE, ENTITY FEE RECEIVED 2 ="Yes"),
- Value if true: IF(AND(OFFER SUBMIT DATE 1 >= OFFER SUBMIT DATE 2, OFFER SUBMIT DATE1 >=5/1/2023, OFFER SUBMIT DATE 1 <=5/31/2023),
- Value if true: “TRUE”,
- Value if false: IF(AND(OFFER SUBMIT DATE 1 < OFFER SUBMIT DATE 2 , OFFER SUBMIT DATE 2 >=5/1/2023, OFFER SUBMIT DATE 2 <=5/31/2023),
- Value if true: “TRUE”,
- Value if false: “FALSE”)))))
I have tried many times but can't seem to get the syntax right. Do I need to break it out into multiple different formulas? If so, how would I write the nested true and false statements?
Thank you!!!
