Round to the nearest tenth, hundredth

With Excel, it's very easy to round to the nearest tenth, hundredth, thousandth, ....

Standard use of the function ROUND

The function ROUND 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 you want to keep

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

Round to the nearest tenth

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

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

Round to tenth = -1

Put the argument at -1 to round to the nearest tenth

=ROUND(1234,-1)   =>1230

ROUND

Round to the nearest tenth

 

 

 

 

 

 

Round to hundredth = -2

Put the argument at -2 to round to the nearest hundredth

=ROUND(1234,-2)   =>1200

Round

Round to the nearest hundredth

Round to thousandth = -3

Put the argument at -3 to round to the nearest thousandth

=ROUND(1234,-3)   =>1000

Round to the nearest thousandth

Round to multiple

Another way to round to the nearest tenth is to use the function MROUND. M stands for Multiple.

=MROUND(1234,10)   =>1230

=MROUND(1234,5)   =>1235

Round multiple

Round to the multiple

Format number to thousandth

You can also customize your format number to divide your numbers by 1000.

This is the technique to use if you want to present your number in K$

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.