Hi, i have a range of sales starting in column Q2 and I need to add a formula that will add a value based on the range of the sale. Say Q3 has a sale value of 43.00 I would want this to return Group A because its within the 0-50 range of sales for first column. The complete list would be:
Group A: 0-50
Group B: 51-99
Group C:100-199
Group D: 200-499
Group E:500-999
Group F: 1000-1999
Group G: 2000 and above
Thanks so much for any help.
Group A: 0-50
Group B: 51-99
Group C:100-199
Group D: 200-499
Group E:500-999
Group F: 1000-1999
Group G: 2000 and above
Thanks so much for any help.