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.
- 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 to hundredth = -2
Put the argument at -2 to round to the nearest hundredth
Round to thousandth = -3
Put the argument at -3 to 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.
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$