Google Sheets Function: ROUND

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

Usage:

=ROUND(number)

or

=ROUND(number, places)


Example of use

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

=ROUND(A2)

google sheets round function integer

This formula is equivalent to:

=ROUND(A2,0)

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

=ROUND(A2,2)

google sheets round function 2 decimals