Many times people work with numbers that are too detailled to present. They may have too many decimal numbers, or perhaps the numbers are so big that rounding them down to thousands may look cleaner. A colleague asked me recently how to round numbers to the nearest thousand. So how do you do it?
The formula arguments are:
= ROUND (number, num_digits)
In below picture cell C6 contains the formula
The formula rounds the value of cell B6 (547,982.00) to 548,000.00. So how does that work?The ROUND function takes the cell reference with a number as first argument. The second argument then instructs the amount of digits to which you want to round the number. A positive number will round a number to the specified amount of decimals and a negative number will round a number to the left of the decimal separator. In this example, using -3 instructs the ROUND function to move the decimal three positions to the left. Or in other words, to the nearest multiple of 1000.
Below table shows the effect of changing the ‘num_digits’ argument from ‘3’ to ‘-3’. It is as if the comma takes a step back with each decrease of the ‘num_digits’ argument.
And that’s how you can ROUND your numbers to the desired output.
Please leave a comment below with questions or suggestions.