ROUNDDOWN

ROUNDDOWN —

ROUNDDOWN(number[,digits])

ROUNDDOWN function rounds a given number towards 0.

number is the number you want rounded toward 0 and digits is the number of digits to which you want to round that number.

If digits is greater than zero, number is rounded toward 0 to the given number of digits.
If digits is zero or omitted, number is rounded toward 0 to the next integer.
If digits is less than zero, number is rounded toward 0 to the left of the decimal point.
This function is Excel compatible.

ROUNDDOWN(5.5) equals 5.

ROUNDDOWN(-3.3) equals -3.

ROUNDDOWN(1501.15,1) equals 1501.1.

ROUNDDOWN(1501.15,-2) equals 1500.0.

Synopsis