Roundup to the nearest 10, 20, 30 etc

[TDL76]

Hello,

I'd like to roundup a list numbers to the nearest 10, 20, 30 etc...
so if a number falls between 1 and 10 will be rounded up to 10 and if a number is between 31 and 40 rounds up to 40.
i.e.

Numbers	Grouped
1	10
3	10
12	20
15	20
23	30
27	30
31	40
38	40
50	50

<TBODY>
</TBODY>

 

[Firefly2012]

You could use CEILING:

Excel 2010
	A	B
6	Numbers	Group
7	59	60
8	38	40
9	76	80
10	44	50
11	7	10
12	73	80
13	42	50
14	60	60
15	4	10
16	27	30
17	89	90
18	100	100
19	48	50
20	45	50
21	61	70
Sheet1

Cell Formulas
Range	Formula
B7	=CEILING(A7,10)

 

[TDL76]

Thank you firefly2012!

That has worked a treat!!
I had tried that but because my data source was decimal format it didn't work! my mistake!

 

[Firefly2012]

You're welcome

Decimal format - do you mean you had fractional values eg 4.765 etc because that should still work with CEILING?

 

[TDL76]

Decimal format being... 0.01 etc... it kept returning 10... so I corrected the formula to read: =CEILING(A2,0.1)
Easy to miss but enough to drive me crazy for a little while

 

[Firefly2012]

Ah understood Glad you got it working!