Author: Oscar Cronquist Article last updated on March 14, 2019

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:

=ROUNDDOWN(B3, C3)

Excel Function Syntax

ROUNDDOWN(number, num_digits)

Arguments

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

Comments

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).