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:

1. Number: This is the value that you want to Round Down.
2. Significance: This is the Multiple that you want to Round Down.

See the Examples in blow Image.