Round Numbers in Google Sheets


Rounding a number reduces the value by a certain number of decimal places making it more manageable by either rounding it up or down depending on the rounding digit.

Google sheets have a rounding function that can achieve this. Let’s take a look at the rules first:

  • If the value of the number to the right of the rounding digit is less than five, the rounding digit is left unchanged.
  • If the value of the number to the right of the rounding digit is higher than five, the rounding digit is raised by one.

For example, 97.98 would become 98 and 97.34 would become 97.

The ROUND Function

The syntax for the ROUND Function is as follows:

=ROUND(value, [places]) where value is the value to be rounded, can also hold the address of the cell containing the value and places is the number of decimal places to round, zero by default.

Demonstrating ROUND Function with different decimal numbers

This function also has two variants, the ROUNDUP and ROUNDDOWN function which, as their names suggest, always round up and round down the values respectively, irrespective of whether the rounding digit is higher or lower than five. The syntaxes are exactly the same too, just put the value followed by the number of places.

And that was how to round numbers in google sheets. With easier to manage values, working on data becomes easier to follow and comprehend by everyone.

Recent Content