November 25, 2020

ROUND function in Google Sheet

ROUND function is used when you want to return a number rounded to a specified number of digits in both Excel & 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.

In the example below, the num_digits is 3 which is greater zero, hence the number is rounded to 3 decimal places.

In the example below, the num_digits is 0, then the number is rounded to the nearest integer.

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.

Leave a Reply

Your email address will not be published. Required fields are marked *