If you have to reduce the value of data entered in Google sheets by a specific number of decimal places, the round function of Google sheets comes in handy. The digits are either rounded up or rounded down to give a whole figure. There are a few rules that users must keep in mind.
Firstly, if the value of the number to the right of the rounding digit is less than 5, the rounding digit remains unchanged.
Secondly, if the value of the number to the right happens to be more than 5, the value of the rounding digit is increased by one.
A lot of students, teachers, and office people find the round function of Google sheets extremely useful. Whenever it comes to rounding off the product prices or marks scored or performing mathematical tasks, the round function makes the process simple.
Now that you know the purpose of the round function, let’s dive straight into how to round in Google sheets.
Steps to round data in Google Sheets:
- Select the cell data for which you want to round up the data, here I have selected the cell A2
- Now to write the formula for the rounding I will select the B2 cell, and write the syntax for rounding up the number which is =ROUND(value, places) here for the value we will take the cell A2 and places is the number of places for which you want to round up the value to and while typing the formula you can also see the format and example how to write the formula:
- After executing the formula you can see the updated or round up value for the number, here in the formula box you can also see the formula for the cell:
- Similarly, you can round up a number by typing the ROUNDUP function and round down by using the ROUNDDOWN function