Rounding Numbers in Google Spreadsheets – Knowligent
Rounding Numbers in Google Spreadsheets

Rounding Numbers in Google Spreadsheets

HomeHow to, TechRounding Numbers in Google Spreadsheets

The ROUND function allows you to reduce a value by a specific number of decimal places.

How to Round Google Sheets Cells to the Nearest 10

In this case, the last digit, the rounding digit, is rounded up or down.

The rules for rounding numbers that Google Spreadsheets follows dictate:

Unlike formatting options that allow you to change the number of decimal places displayed without actually changing the value in the cell, the ROUND function, like Google Sheets' other rounding functions, actually changes the value of the data.