It’s always a better idea to keep the numbers simple. So here comes the importance of round functions in Google Sheets.
There are certain rules in rounding numbers. The round functions in Google Sheets are no exception to this. Here in this post we can quickly learn how to use Google Sheets three commonly using round functions and how they round numbers.
There are three round functions in general use. They are ROUND, ROUNDUP and ROUNDDOWN.
How to Use ROUND Functions in Google Sheets
Syntax: ROUND(value, places)
ROUND function rounds a given number to a certain number of decimal places. See the example below.
How to Use ROUNDUP Formula in Google Sheets
Syntax: ROUNDUP(value, places)
Like ROUND function, ROUNDUP function also rounds a number to a certain number of decimal places. But the difference, it always rounding up to the next valid increment.
How to Use ROUNDDOWN Formula in Google Sheets
Syntax: ROUNDDOWN(value, [places])
Like ROUNDUP function, ROUNDDOWN function also rounds a number to a certain number of decimal places. But here it rounding down to the next valid increment.
ROUND function with SUMIF
Similarly you can use ROUNDUP as well as ROUNDDOWN functions with SUMIF.
ROUNDDOWN function with DSUM
ROUNDUP function with SUMPRODUCT
When we use Google Sheets to create invoices or anything related to money, it is better to limit the number of decimal places to two or zero. You can use round function in such cases. A simple number is always easy to remember.
There are few more round functions like Trunc, Mround etc. I think it’s better to write a separate post for that. Any how, the above three are the most commonly using Round Functions in any calculations.