FLOOR Function in Excel
The FLOOR Function Rounds a Number Down to its Nearest Multiple of Significance. FLOOR Function helps us round Down the numbers as per the requirement.
Syntax:
=FLOOR(Number,Significance)
Arguments:
Number: This is the value that you want to Round Down.
Significance: This is the Multiple that you want to Round Down.
See the Examples in blow Image.