Not considering entire condition

Question

When I click on RUN, it is just considering the 1st line of condition which is of "30" and ignoring the rest. I'm clueless as I'm new to Alteryx

Can someone help me here?

IF [Days Pending for - PT]>30 THEN ">30 Days"
ELSEIF [Days Pending for - PT]>19 THEN "20-30 Days"
ELSEIF [Days Pending for - PT]>9 THEN "10-20 Days"
ELSEIF [Days Pending for - PT]>5 THEN "6-10 Days"
ELSEIF [Days Pending for - PT]<6 THEN "0-5 Days"
ELSE "NA"
ENDIF

IraWatt · Accepted Answer

Hey @Abhishekjoshua, If statements apply the logic in the order you right them AKA they apply the first rule which works. I would write that statement like this: IF [Days Pending for - PT]<6 THEN "0-5 Days" ELSEIF [Days Pending for - PT]<11 THEN "6-10 Days" ELSEIF [Days Pending for - PT]<21 THEN "10-20 Days" ELSEIF [Days Pending for - PT]<31 THEN "20-30 Days" ELSEIF [Days Pending for - PT]>30 THEN ">30 Days" ELSE "NA" ENDIF The community has some quick and easy videos on formulas and the Formula Tool here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Writing%20Expressions Any questions or issues please ask :) HTH! Ira