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 Sheets.

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.