Help me with my Switch statement...hey i tried ;-)

[unclejemima]

Well, I gave it a crack.  Not right, but can someone help me with making this correct.

DayOldCategory = switch(Invoice[DaysOld], 
    <-30 && >-59,"30-60",
    <-60 && >-89,"60-90",
    <-90 && >-999, "120+")

If invoice[daysold] is between -30 and -59, I want to have text "30-60", between -60 and -89, then "60-90"text, and finally over -90 to show text "120+)

Please and thank you 🙂

[Anonymous · Accepted solution]

@unclejemima here is the fixed calculation.

SWITCH(TRUE(),

Invoice[DaysOld]<-30 && Invoice[DaysOld]>-59,"30-60",

Invoice[DaysOld]<-60 && Invoice[DaysOld]>-89,"60-90",

Invoice[DaysOld]<-90,"120+",

"Other")

[unclejemima]

awesome thank you!  marked as answer!!!

[unclejemima]

Anyone???  I think the formula is close but not quite right.  Please help 🙂