Excel FLOOR function

Function              FLOOR

Description        Excel FLOOR function returns a provided number rounded down to a specified multiple.

Syntax  FLOOR(number, multiple)

number  The number to be rounded down.

multiple  The multiple to use when rounding down.

Example:

=FLOOR(236,5) = 235

=FLOOR(237,5) = 235

=FLOOR(238,5) = 235

=FLOOR(239,5) = 235

=FLOOR(241,5) = 240