Google Sheets Function: ROUND

The ROUND function rounds a value based on the defined number of decimal places.




=ROUND(number, places)

Example of use

To round a number to 0 decimal places and get an integer, enter:

google sheets round function integer

This formula is equivalent to:


To round a number to 2 decimal places, enter 2 as the second argument:

google sheets round function 2 decimals