Round to Nearest 10, 100, or 1000 – Excel & Google Sheets

This tutorial will demonstrate how to round to the nearest 10, 100, or 1000 in Excel & Google Sheet.

Round 10 100 1000 Formula main

Round Function

The ROUND Function rounds a number to a specified number of digits relative to the decimal.

=ROUND(B3,0)

Round

By using negative numbers you can round to the nearest 10, 100, or 1000.

Round to Nearest 10

=ROUND(B3,-1)

Round to Nearest 100

=ROUND(B3,-2)

Round 100

Round to Nearest 1000

=ROUND(B3,-3)

Round 1000

Round Up or Round Down to Nearest 100

You can use the ROUNDUP or ROUNDDOWN functions to round a number up or down instead of using standard rounding rules. Here we will use these functions to round to the nearest 100.

ROUNDUP Function

=ROUNDUP(B3,-2)

Roundup 100

ROUNDDOWN Function

=ROUNDDOWN(B3,-2)

Rounddown 100

Round to Nearest 10, 100, or 1000 in Google Sheets

All of the above examples work exactly the same in Google Sheets as in Excel.

Round 10 100 1000 Formula Google

 

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!