You often come across values that you need to round off in a data set. It could be rounding up a number to the nearest two decimal points. You might need to round down a number to the nearest whole number or integer. Google Sheets provides four functions for this. Let’s cover them today.
4 ways to round numbers in Google Sheets
The four main functions to round numbers are ROUND, ROUNDUP, ROUNDDOWN and MROUND.
Rounding up on Google Sheets follows the general rules as explained below:
- If the number to the right of the digit to be rounded is less than five, then the digit remains the same.
- If the number to the right of the digit to be rounded is more than or equal to five, then the function increments the number by 1.
Method 1: Using ROUND function
1.1 Rounding off to the nearest whole number
1.2 Rounding off number to set decimal points
1.3 Rounding off numbers beyond the decimal point
Method 2: Using ROUNDUP function
2.1 Rounding up numbers to the next whole number
2.2 Rounding up numbers while keeping set decimal points intact
2.3 Rounding up numbers beyond decimal places
Method 3: Using ROUNDDOWN function
3.1 Rounding down numbers to the next whole number
3.2 Rounding down numbers while keeping set decimal points intact
3.3 Rounding down numbers beyond decimal places
Method 4: Using MROUND function
Let’s go over the functions in detail.