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 : )
Thank you all @atcodedog05 and @Kamran1991 that worked!
Happy to help : ) @CamilleB
Cheers and have a nice day!