Short Tutorial on Rounding Numbers to the Nearest 10, 100, and 1000 With Example
You can use negative number digits to remove all the decimals and round off integer to the nearest 10s, 100s and 1000s.
Rounding Numbers to the Nearest 10, 100, 1000
Use the Round() function to round integers to the nearest 10, 100, 1000 as explained in the simple steps below.
Step 1: Enter the set of decimal integers. Type the syntax =ROUND( inside a cell. Click on the first cell location from where you wish to round the values. Put a comma symbol (,) and type -1. Close the parenthesis.
Step 2: Hit enter button to get the result to the nearest 10s.
Step 3: Drag the mouse pointer from the right corner until the last field. You can see here the resultant of nearest ten values of each.
Similarly the decimal places rounds to nearest 100 for -2, nearest 1000 for -3 and so on..