# rounding in excel

February 6, 2008 3:48 PM Subscribe

Rounding in Excel?

I have a formula in excel that results in numbers like 1551, 1208, etc.

I would like to round to the nearest ten or one hundred, so the results would be 1550 or 1210, for example. I might also want to round up or down to the hundred, to 1600 or 1200 in those examples.

Help!

I have a formula in excel that results in numbers like 1551, 1208, etc.

I would like to round to the nearest ten or one hundred, so the results would be 1550 or 1210, for example. I might also want to round up or down to the hundred, to 1600 or 1200 in those examples.

Help!

Look at the Round, Roundup and Rounddown functions in the help files. Very straightforward.

posted by jon1270 at 3:52 PM on February 6, 2008

posted by jon1270 at 3:52 PM on February 6, 2008

You want to use the ROUND command. To get 1550 from 1551, you would do:

=ROUND(1551,-1)

Where the -1 rounds to the left of the spot.

posted by selfnoise at 3:54 PM on February 6, 2008

=ROUND(1551,-1)

Where the -1 rounds to the left of the spot.

posted by selfnoise at 3:54 PM on February 6, 2008

Wait, nevermind.. what you actually want is:

=ROUND(A1/10, 0)*10

Where A1 is the source value. I forgot for some reason that INT() truncates the decimal.

posted by spiderskull at 3:54 PM on February 6, 2008

=ROUND(A1/10, 0)*10

Where A1 is the source value. I forgot for some reason that INT() truncates the decimal.

posted by spiderskull at 3:54 PM on February 6, 2008

Also CEILING and FLOOR if you want to always round up or round down.

posted by XMLicious at 5:04 PM on February 6, 2008

posted by XMLicious at 5:04 PM on February 6, 2008

MROUND if you want to round by something other than decimals.

posted by GarageWine at 8:43 AM on February 7, 2008

posted by GarageWine at 8:43 AM on February 7, 2008

This thread is closed to new comments.

=INT(A1/10)*10

in the cell.

posted by spiderskull at 3:51 PM on February 6, 2008