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

Syntax

=ROUNDDOWN(number,num_digits)

Arguments

Argument Description
number The number that you want to round
num_digits The number of digits to which you want to round the number argument

  if num_digits is positive, number is rounded down to the specified number of decimal places
  if num_digits is 0 (zero), number is rounded to the nearest integer
  if num_digits is negative, number is rounded down to the left of the decimal point

Examples

  A B C
1 Formula Result Notes
2 =ROUNDDOWN(4.3,0) 4 Rounds 4.3 down to zero decimal places
3 =ROUNDDOWN(3.14159,3) 3.141 Rounds 3.14159 down to three decimal places
4 =ROUNDDOWN(-3.14159,1) 3.1 Rounds -3.14159 down to one decimal place
5 =ROUNDDOWN(2143.141,-2) 2100 Rounds 2143.141 down to two decimal places to the left of the decimal point