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.

[TABLE="width: 8"]
<TBODY>[TR]
[TD]Numbers[/TD]
[TD]Grouped[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]38[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]50[/TD]
[TD]50[/TD]
[/TR]
</TBODY>[/TABLE]

 

[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!