ROUNDDOWN
Rounds a number down, toward zero.
Syntax
ROUNDDOWN(number,num_digits)
Number is any real number that you want rounded down.
Num_digits is the number of digits to which you want to round number.
Remark
- ROUNDDOWN behaves like ROUND, except that it always rounds a number down.
- If num_digits is greater than 0 (zero), then number is rounded down to the specified number of decimal places.
- If num_digits is 0 or omitted, then number is rounded down to the nearest integer.
- If num_digits is less than 0, then number is rounded down to the left of the decimal point.
Examples
ROUNDDOWN(3.2, 0)
equals 3
ROUNDDOWN(76.9,0)
equals 76
ROUNDDOWN(3.14159, 3)
equals 3.141
ROUNDDOWN(-3.14159, 1)
equals -3.1
ROUNDDOWN(31415.92654, -2)
equals 31,400