# Round to the Nearest Tenth, Hundredth with Excel Last Updated on 01/08/2023

With Excel, it's very easy to round to the nearest tenth, hundredth, thousandth, .... The technique reveals in this article

## Standard use of the ROUND function

The ROUND function is a very common Excel function. The ROUND function is used to round a number to a specified number of digits. The syntax of the ROUND function is as follows:

=ROUND(number, decimal)

• "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 digits.

## Round to the nearest tenth, hundredth, thousandth

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 to hundred = -2

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

=ROUND(1234,-2)   =>1200

• Round to thousand = -3

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

=ROUND(1234,-3)   =>1000

## The function MROUND

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

Or 5 to round to the nearest five.

=MROUND(1234,5)   =>1235

## Articles related # Round to the Nearest Tenth, Hundredth with Excel

Last Updated on 01/08/2023

With Excel, it's very easy to round to the nearest tenth, hundredth, thousandth, .... The technique reveals in this article

## Standard use of the ROUND function

The ROUND function is a very common Excel function. The ROUND function is used to round a number to a specified number of digits. The syntax of the ROUND function is as follows:

=ROUND(number, decimal)

• "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 digits.

## Round to the nearest tenth, hundredth, thousandth

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 to hundred = -2

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

=ROUND(1234,-2)   =>1200

• Round to thousand = -3

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

=ROUND(1234,-3)   =>1000

## The function MROUND

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

Or 5 to round to the nearest five.

=MROUND(1234,5)   =>1235