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

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

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