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

Sommaire

## 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 to hundredth = -2

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

=ROUND(1234,-2) =>1200

### Round to thousandth = -3

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

=ROUND(1234,-3) =>1000

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

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