Google Sheets: How to Round Numbers

Google Sheets offers most of if not all the options that Office Excel does – this includes functions like rounding numbers. If you’d like to round something in a Google sheet, here is how to do it.

You’ll need to use a formula – the Round formula, to be precise. Click into an empty cell and type =ROUND(number), then press enter. The number you entered will be rounded up or down to the last decimal place. For example, 9.52 will be rounded to 9.50.

Tip: Rounding in this way follows the normal rules – the numbers 0,1,2,3 and 4 will be rounded down, while 5,6,7,8 and 9 will be rounded up.

If you want to round your number to a specific number of decimals, you can do that too. It’s the same formula but in a slightly different format. Type =ROUND(number, decimals) and press enter.

An example would be =ROUND(9.1283912893, 2). In this case, the resulting number would be 9.13.

Tip: If you want to round your number up, ignoring the normal rules of rounding up for digits of 5 and above, and down for 4 and below, you need to use the =ROUNDUP(number, decimals) formula instead. =ROUNDUP(28.123, 2) will result in 28.13 (instead of 28.12 as it would be in ROUND). Similarly, the opposite would be =ROUNDDOWN(number, decimals). In this case, the number will always be rounded down, and =ROUNDDOWN(28.128, 2) becomes 28.12 (instead of 28.13 as it would be in ROUND).