The ROUND function in Google sheets is to reduce any value by a specific number of decimal places. When you do that, the final digit is rounded either up or down.
There are different rounding functions — ROUND, ROUNDUP, ROUNDDOWN, MROUND.
The ROUND function has standard rules which is applicable when it takes a number to a certain number of decimal places.
The standard rules indicates that when rounding to a particular decimal place, the most significant digit to the right is considered. If this digit is greater than or equal to the number 5; the digit is rounded up. If it is less than 5 then the digit is rounded down.
For example, if you want to round up the number 1.362 to a certain decimal place and the number to be rounded is 6, to the right is 2 and since 2 is less than 5 the result will be 1.36. On the other hand, if the number is 1.368, 8 is higher than 5 so you increase 6 by 1 and the end result is 1.37.
This article will show you how to ROUNDUP and ROUNDDOWN in Google sheets.
How to round in Google Sheets
First let’s look at the syntax for the ROUND function in Google sheets.
A function’s syntax is the layout of the function and it includes the function’s name, brackets and argument.
Syntax for ROUND function is ROUND(value, [places])
Value is required because it is the number you want to round. It can be a numeric value or a reference to a cell containing a numeric value.
Place is optional and it is the number of digits or decimal places to which you want to round the value to . Since it’s optional, when it’s not specified it is 0 by default.
It is important to note that the ROUND function in Google spreadsheet alters the value of the data , unlike the formatting option that allows you to change the number of decimal places displayed without changing the cell’s value. So using the ROUND function to round your data will definitely affect the results of calculations.
Here’s How to ROUND in Google Sheet:
- Open a new blank spread sheet
- Then fill the cells with the following: A1:C1 , 25.255, 10,252.55
- Select cell A2
- Select Insert menu
- Select Function
- Go to Math
- Select ROUND
- Select cell A1 then press Enter
- Then use the fill handle to drag the row across and copy the formula to B2 and C2. The rounded results will appear
How to ROUNDDOWN numbers in Google sheets
The ROUNDDOWN function reduces a value by a specific number of decimal places or digits. It always leaves the rounding digit unchanged, never rounds it up.Also alters the value of the data in cell meanwhile the formatting option will allow you change the number of decimal places displayed without changing the value in the cell.
This function also affects the results of calculations because of the change in data. Always rounds towards zero. Negative number even if they are increased in value by the function are rounded down.
Let’s say the value of count’s argument is set to “-1”,this function will remove all the digits to the right of the decimal point, it will round the first digit to the left of the decimal point down to 10.
Or if you set it the value of count argument to “-2”. The function will remove all digit to the righr of the decimal point, it rounds the 1st and 2nd digits to the left of the decimal point and down to 100.
ROUNDDOWN Function’s Syntax And Argument
A function’s syntax is the layout of the function and it includes the function’s name, brackets and argument.
Syntax for ROUNDDOWN function is =ROUNDDOWN (number, count)
Number which is the value to be rounded is a required option. This argument contains actual data for rounding. It can be a cell reference to the location of the data in the worksheet.
Count on the other hand is the number of decimal places to leave. It is optional and can be omitted.
If you omit count argument, the function will round the value down to the nearest integer.If the count argument is set to 1,the function leaves only one digit to the right if the decimal point and rounds it down to the next number.
If count argument is negative, all decimal places are removed and the function rounds up the number of the digits to the left of the decimal point downward.
How to ROUNDDOWN numbers in Google Sheets
- Open a new blank spreadsheet
- Enter the following in each cells, A1: 25.255 and Cell C2: 10,252.55
- Select cell A2
- Select Insert menu, go to Function, Go to Math, Select ROUNDDOWN
- Select cell A1, press Enter
- Use the fill hand to drag the row across and copy the formula to B2 and C2. The results will appear rounded down with two digits to the right of the decimal
