# Group Values into Multiples of 100 (?)

#### zraj07

##### Board Regular
You have a column of values in A: Say 3, 55, 68, 98, 105, 210, 280, 300, 301, 367

You want to assign a value to each number, using multiples of 100

For instance, 3, 55, 68, and 98 would each get a value of 100 assigned to them in Column B, 105 would get a value of 200 assigned to it, 210, 280, and 300 would get a values of 300, and 301, 367 would get values of 400.

Any suggestions ?

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### Gerald Higgins

##### Well-known Member
Code:
``=roundup(a1,-2)``

#### zraj07

##### Board Regular
This did it..Thanks very much!

Replies
1
Views
196
Replies
4
Views
947
Replies
24
Views
1K
Replies
3
Views
1K
Replies
3
Views
189

1,190,768
Messages
5,982,824
Members
439,799
Latest member
matts12

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back