Download the example workbook
This tutorial will demonstrate how to round to the nearest 10, 100, or 1000 in Excel & Google Sheets.
The ROUND Function rounds a number to a specified number of digits relative to the decimal.
By using negative numbers you can round to the nearest 10, 100, or 1000.
Round to Nearest 10
Round to Nearest 100
Round to Nearest 1000
Round Up or Round Down to Nearest 100
Easy Excel Automation
Add Excel automation to your workbook with just a few clicks.
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.