Excel Function : FLOOR
Category
Compatibility
Description
Rounds a number down, toward zero
Microsoft Excel Reference Page
https://support.office.com/en-us/article/FLOOR-function-14bb497c-24f2-4e04-b327-b0b4de5a8886
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.