Using MRound

Rhonda

New Member
Joined
Jul 28, 2005
Messages
36
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
 

Some videos you may like

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
Joined
Oct 3, 2005
Messages
1,569
Good afternoon Rhonda

Try using the CEILING function thus :

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

Both will return 58000.

HTH

DominicB
 

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Try this function instead of mround.

=CEILING(A1,1000)
 

Watch MrExcel Video

Forum statistics

Threads
1,114,093
Messages
5,545,916
Members
410,711
Latest member
Josh324
Top