ROUNDDOWN:
Rounds a number down, toward zero
The ROUNDDOWN function rounds a number down, toward zero.
ROUNDDOWN takes
1 required argument and
1 optional argument:
Syntax: ROUNDDOWN(number,
[num_digits])
Using the ROUNDDOWN function:
The arguments for the ROUNDDOWN function are:
Argument

Required?

Description

number 
Required 
Any real number that you want rounded down. 
num_digits 
Optional 
The number of digits to which you want to round the number argument. 
• 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, 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. 
The ROUNDDOWN function rounds a number down, toward zero.