Skip to main content

ROUND

The ROUND function rounds a number to a specified number of decimal places.

Syntax​

=ROUND(number, num_digits)

Parameters​

  • number: The number you want to round
  • num_digits: The number of digits to round to (positive for decimals, negative for left of decimal)

Examples​

=ROUND(123.456, 2) // Returns 123.46
=ROUND(123.456, 0) // Returns 123
=ROUND(123.456, -2) // Returns 100