August 2, 2021

# ROUND function in Excel

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

` =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.

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

`=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 A2 is rounded to 3 decimal places, which is 522.546. In the same example, we have changed the argument num_digits as 0 in the ROUND function in cell B2. Hence here the number in cell A2 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 Google Sheet.

Check here to learn MROUND function in Excel.

Check here to learn MROUND function in Google Sheet. #### abhraisraja

View all posts by abhraisraja →