ROUND function is used when you want to return a number rounded to a specified number of digits in Google Sheet.

=ROUND(number, num_digits)

**number –**The number that you would like to round.**num_digits –**The no. of digits to which you want to round the number. It’s optional argument. If it’s not specified then 0 will be considered as default.

Let’s understand with a simple example. In the below table we have added the following formula in cell B1.

=ROUND(A2,3)

Here in the ROUND function, the argument **num_digits **is mentioned as 3, which is greater than zero, hence the number in cell A1 is rounded to 3 decimal places, which is 522.546.

In the same example , we have removed the optional argument **num_digits** from the ROUND function in cell B1. Hence here the number in cell A1 is rounded to it’s nearest integer, which is 523.

#### Notes :

- If
**num_digits**is less than 0, then the number is rounded to the specified number of places to the left of the decimal point.- For example, =ROUND(522.51,-1) would return 520.
- For example, =ROUND(522.51,-2) would return 500.
- For example, =ROUND(522.51,-3) would return 1000.
- For example, =ROUND(522.51,-4) would return 0.

Check here to learn ROUND function in Excel.