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.