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