Formula Cluster help please

[chef]

Hi
I am getting myself in knots trying out all sorts if and and statements and would appreciate some help with formula starting at cell Z6

I have a range of values in column Q and in column Z, I am trying to put in some values so I can cluster payments with following results

If 0 then1, 1-50 =2, 51-100=3, 101-150=4, 151-200 =5, 201-250 =6, 251-300 = 7 and if >300 then =8

Any help would be greatly appreciated
regards

 

[Joe4]

For a value in cell Q1, enter this formula in cell Z1:

=MIN(INT((Q1+49)/50)+1,8)

 

[chef]

wow, wow then more wow
worked perfect and that's just genius !!

thank you so much

 

[Joe4]

You are welcome.
Glad I was able to help!

Here is another very similar, but slightly simpler version that will yield the same results:

=MIN(INT((Q1+99)/50),8)

 

[chef]

Any chance you can download your brain

 

[Joe4]

Any chance you can download your brain