**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)

- "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 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