### 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 Function

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

`=ROUND(B3,0)` 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 to Nearest 1000

`=ROUND(B3,-3)` ## 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)` ### ROUNDDOWN Function

`=ROUNDDOWN(B3,-2)` ## 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. ## Excel Practice Worksheet

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