Author: Oscar Cronquist Article last updated on May 04, 2022

The ROUNDDOWN function calculates a number rounded down based on the number of digits to which you want to round the number.

Formula in cell D3:


Excel Function Syntax

ROUNDDOWN(number, num_digits)


number Required. The value to round.
num_digits Required. A number representing the digit you want to round down to.


The ROUNDDOWN function rounds

  • down to the given decimal if num_digit is larger than 0 (zero).
  • down to the nearest integer if num_digit is 0 (zero).
  • down to the number to the left of the decimal point if num_digit is less than 0 (zero).