In Excel, the FLOOR function returns a number rounded down based on a multiple of significance.
The syntax for the FLOOR function is:
FLOOR( number, significance )
number is the number that you wish to round down.
significance is the multiple of significance that you wish to round a number to.