# Using MRound

#### Rhonda

##### New Member
Need to round all numbers in a column up to the highest 1,000, even if the number would normally be rounded down, i.e. below 500
E.G.
57,900 needs to be rounded to 58,000
57,001 also needs to be rounded to 58,000

As soon as the number goes over the 1,000 I need to round it up to the next thousand.

I tried MROUND as follows
=MROUND(57,900,1000) and it rounded up property to 58,000
=MROUND(57,001,1000) and it rounded to 57,000 - I need it rounded to 58,000

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

#### DominicB

##### Well-known Member
Good afternoon Rhonda

Try using the CEILING function thus :

=CEILING(57900,1000)
=CEILING(57100,1000)

Both will return 58000.

HTH

DominicB

#### Jonmo1

##### MrExcel MVP
Try this function instead of mround.

=CEILING(A1,1000)

Replies
2
Views
76
Replies
6
Views
127
Replies
2
Views
82
Replies
3
Views
91
Replies
1
Views
229