ROUND

  • Updated

Rounds a given number to a specified number of digits.

Sample Usage

ROUND(A2,3)
ROUND(15.55,1)
ROUND(21.5,-1)

Syntax

ROUND(number, [count])

  • number - The number to be rounded.
  • count - [OPTIONAL] The number of places to which the number is to be rounded.

Examples

ROUND(15.55,1) rounds 15.55 to one decimal place, and returns 15.6.
ROUND(21.5,-1) rounds 21.5 to one decimal place to the left of the decimal point, and returns 20.


Notes

  • If count is greater than 0 (zero), then number is rounded to the specified number of decimal places.
  • If count is 0, the number is rounded to the nearest integer.
  • If count is less than 0, the number is rounded to the left of the decimal point.
  • To always round up (away from zero), use the ROUNDUP function.
  • To always round down (toward zero), use the ROUNDDOWN function.
  • To round a number to a specific multiple (for example, to round to the nearest 0.5), use the MROUND function.
  • When rounding to a particular place, the next most significant digit (the digit to the right) is considered. If this digit is greater than or equal to 5, the digit is rounded up, otherwise it is rounded down. This occurs irrespective of sign; that is, 'up' and 'down' are in terms of magnitude.