Excel ROUNDDOWN function

Function              ROUNDDOWN

Description        Excel ROUNDDOWN function rounds down number to a given number of digit after or before decimal.

Syntax  ROUNDDOWN(number, num_digits)

number  The number to rounded down.

num_digits  The number of digits up to which rounding down number has to be rounded down.

Example:

=ROUNDDOWN(2.3456,2) = 2.34

=ROUNDDOWN(2.3126,2) = 2.31

=ROUNDDOWN(12.789,1) = 12.7

=ROUNDDOWN(12.789,-1) = 10

Usage Note:

  • When the num_digits is positive it rounds down right to the decimal point and when it is negative it rounds down left to the decimal point.
  • If the num_digits is 0 then rounds down to the nearest integer.