Rounding Numbers to the Nearest 10, 100, and 1000 With Example

Short Tutorial on Rounding Numbers to the Nearest 10, 100, and 1000 With Example

Round Numbers to the Nearest 10, 100 or 1000

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.
Rounding Number To Nearest 10s Step1
Step 2: Hit enter button to get the result to the nearest 10s.
Rounding Number To Nearest 10s Step2
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.
Rounding Number To Nearest 10s Step3

Similarly the decimal places rounds to nearest 100 for -2, nearest 1000 for -3 and so on..