Round to the Nearest Ten, Hundred, Multiple..

With Excel, it's very easy to round to the nearest ten, hundred, thousand, ....

Standard use of the ROUND function

The ROUND function is a very common Excel function. You use it when you want to round a number.

=ROUND(number, decimal)

  • "Number" is your number
  • "Decimal" is the number of decimal places you want to keep

You can put any value, including 0, if you don't want to return a decimal.

Round to the nearest ten

The technique to round to the nearest ten is very simple.

You have to use the same function but the decimal argument will be negative

Round to tenth = -1

Set the argument to -1 to round to the nearest ten

=ROUND(1234,-1)   =>1230

ROUND
Round to the nearest ten

Round to hundred = -2

Set the argument to -2 to round to the nearest hundred

=ROUND(1234,-2)   =>1200

Round
Round to the nearest hundred

Round to thousand = -3

Set the argument to -3 to round to the nearest thousand

=ROUND(1234,-3)   =>1000

Round to the nearest thousand

Round to multiple

Another way to round to the nearest ten, five, etc. is to use the function MROUND. M stands for Multiple, where you set the argument to the nearest multiple you want to round to. For example, 10 if you want to round to the nearest ten or 5 to round to the nearest five.

=MROUND(1234,10)   =>1230

=MROUND(1234,5)   =>1235

Round multiple
Round to multiple

Format number (from 1000 to 1K)

You can also format your number when you divide it by 1000.

This is the technique to use if you want to present your number in K$, for example.

Related posts


Permanent link to this article: https://www.excel-exercise.com/round-to-the-nearest-tenth-hundredth/


Leave a Reply

Your email address will not be published.