Conditional Statement Help

[CamilleB]

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.

[atcodedog05]

.

[atcodedog05 · Accepted 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 : )

[Kamran1991 · Accepted solution]

 

I hope the attached solution will work

 

[CamilleB]

Thank you all @atcodedog05 and @Kamran1991 that worked!

[atcodedog05]

Happy to help : ) @CamilleB 

Cheers and have a nice day!