Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
Hi I am needing help in converting the following excel formula to Alteryx:
=IF(AND(B2<40,A2="Active"),$E$2,IF(AND(B2<50,A2="Active"),$E$3,IF(AND(B2<55,A2="Active"),$E$4,IF(AND(B2>=55,A2="Active"),$E$5,$E$6))))
I have attached a shortened version of the spreadsheet I am working with just to give context.
So far I have the following formula, I know I am definitely missing something:
Any help/guidance that can be provided would be greatly appreciated.
Solved! Go to Solution.
Hi @CamilleB
Here is how you can do it. The formula would be like below. $E$2 absolute cell referencing cant be used in alteryx 😅
Workflow:
Hope this helps : )
I hope the attached solution will work
