Multi-condition If Statement with a range as a condition

I have a multi-condition IF formula that needs help. I have a data set that needs to return a label for multiple conditions. My formula is not working when one of the conditions is a range. I would appreciate any advice on how I can improve the formula

Examples:

If the data is between 5 and 10, then "5-10"

If the data is between 11 and 14, then "10-14", Else ">14"

I have tried -, AND, as well as && to define the ranges without success.

Data of 5 or 11, will return the labels, but nothing else in the defined ranges

I would appreciate any advice on how I can improve the formula

Help

Accepted answers

All comments

Hi @angeline559

One way of doing this, check the attached workflow

Multi-condition If Statement with a range as a condition.yxmd

Alteryx doesn't have a Between operator

try:

IF [my field] >= 5 and [my field] <= 10 THEN "5-10"

ELSEIF [my field] >= 11 and [my field] <= 14 THEN "10-14"

ELSE "> 14"
ENDIF

Chris

See if this works

Thank you, @Felipe_Ribeir0 and @ChrisTX Seems obvious now that I can see it. Appreciate your assistance.

Hi @angeline559

I am glad it worked. If you could mark the answers that helped you as a solution, i would be even more glad .

Quick Links

Tags

This months top contributors

AkimasaKajitani 387

Hollingsworth 335