Range or similar formula?

[BT690]

Hi

I have a spread sheet with a couple of thousand cells of decimal numbers between two values of 0 & 10. I want to use some type of formula that will put them into five ranges eg "0> & <2"=1, ">2 & <4" =2 etc. What is the best formula to apply in this instance please.

Thanks

BT

 

[mikerickson]

How about =ROUNDUP(A1/2, 0)

 

[BT690]

How about =ROUNDUP(A1/2, 0)

Too easy, thanks.

I used ROUNDUP first then tried to apply RANGE, IF, MAX etc......answer was staring me in the face all the time

Cheers,

BT

 

[thespardian]

Please try this.
=INDEX({1,2,3,4,5,6},MATCH(A1,{0,2,4,6,8,10},1))

just change the cell reference accordingly