How to use Round Functions in Google Sheets [ROUND, ROUNDUP, ROUNDDOWN]

0
95
Round Functions in Google Sheets

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.

round formula in google sheets

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.

ROUNDUP Formula in Google Sheets

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.

ROUNDDOWN Formula

The above are the examples to how to use the ROUND Functions in Google sheets. You can use round functions with functions like SUM, DSUM, SUMPRODUCT, SUMIF etc. See few examples below.

ROUND function with SUMIF

Similarly you can use ROUNDUP as well as ROUNDDOWN functions with SUMIF.

=round(sumif(B5:E9,B13,C5:C9),0)

ROUNDDOWN function with DSUM

=rounddown(dsum(B6:D14,3,B2:D4),1)

ROUNDUP function with SUMPRODUCT

=roundup(sumproduct((B7:B14=”Myron Ambriz”)*((C7:C14=”North”)+(C7:C14=”South”))*(D7:D14)),0)

Conclusion:

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.

LEAVE A REPLY

Please enter your comment!
Please enter your name here