Skip to main content

ROUNDDOWN

The ROUNDDOWN function rounds a number down toward zero to a specified number of decimal places.

Syntax​

=ROUNDDOWN(number, num_digits)

Parameters​

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

Examples​

=ROUNDDOWN(3.7, 0) // Returns 3
=ROUNDDOWN(123.456, 2) // Returns 123.45
=ROUNDDOWN(123.456, -2) // Returns 100