The ROUND function rounds a number to a specified number of digits.




Argument Description
number The number that you want to round
num_digits The number of digits to which you want to round the number argument

  if num_digits is positive, number is rounded to the right of the decimal point
  if num_digits is 0 (zero), number is rounded to the nearest integer
  if num_digits is negative, number is rounded to the left of the decimal point


  A B C
1 Formula Result Notes
2 =ROUND(2.15,1) 2.2 Rounds 2.15 to one decimal place
3 =ROUND(-1.475, 2) -1.48 Rounds -1.475 to two decimal places
4 =ROUND(21.5, -1) 20 Rounds 21.5 to one decimal place to the left of the decimal point
5 =ROUND(626.3,-3) 1000 Rounds 626.3 to the nearest multiple of 1000
6 =ROUND(-50.55,-2) -100 Rounds -50.55 to the nearest multiple of 100