Conditional Statement Help

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.

Alteryx Help.xlsx

Workflow

Common Use Cases

Accepted answers

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 : )

Age Bracket.PNG

I hope the attached solution will work

Age Bracket.PNG

Age Bracket.yxmd

All comments

.

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 : )

Age Bracket.PNG

I hope the attached solution will work

Age Bracket.PNG

Age Bracket.yxmd

Thank you all @atcodedog05 and @Kamran1991 that worked!

Happy to help : ) @CamilleB

Cheers and have a nice day!

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15867

MarqueeCrew 13708

apathetichell 13703