Help with Switch Function

[bouyazbekj]

Hello everyone. 

Im the table attached I want to create a "Status" column where I want a switch function to group days outstanding into 4 categories.. 0-50 days, 51-75 days, 76-90 days, 91+ days. See below for example 

Invoice number	Days outstanding	Status
20460	16	0-50 Days
20459	25	0-50 Days
20458	32
20457	48
20456	50
20455	55	51-75
20454	58
20453	59
20452	70
20451	75
20450	77	76-90 Days
20449	90	76-90 Days
20448	92	91+ Days
20447	99
20446	99
20445	105

[HotChilli · Accepted solution]

Column = switch(TRUE(), Table1[Days outstanding] < 51, "0 - 50 Days",
                        Table1[Days outstanding] < 76, "51 - 75 Days",
                        Table1[Days outstanding] < 91, "76 - 90 Days", "91 + Days")

Please test it because I just bashed it out without doing so