ROUND()
Rounds a number to a specified number of digits.
ROUND(number, num_digits)ROUND rounds number to num_digits decimal places using standard rounding — 0.5 and above rounds up. Positive num_digits rounds to decimal places, 0 rounds to the nearest whole number, and negative values round to the nearest 10, 100, and so on.
Rounding changes the actual stored value, not just its display — use a number format instead if you only want to change how a number looks.
Arguments
- number
- The number to round.
- num_digits
- How many digits to round to. Negative rounds to the left of the decimal point.
Examples
=ROUND(12.345, 2)→12.35
Rounds to 2 decimal places.
=ROUND(1284, -2)→1300
Rounds to the nearest hundred.