Excel Function : FLOOR
Rounds a number down, toward zero
Microsoft Excel Reference Page
Syntax and Description of the FLOOR Excel Function
The syntax for the FLOOR function in Microsoft Excel is: FLOOR( number, significance ) where the number argument is the value to round, and the significance argument is the multiple to which you want to round the number.
About FLOOR Excel Function
FLOOR(number,significance) The FLOOR function rounds a number down to the nearest multiple of significance.