ExcelHeroThe FLOOR function
Rounds down to a multiple of a step.
In German Excel: UNTERGRENZE
How to write it
=FLOOR(number, significance)- number
- The number to round.
- significance
- The step, like 15 for quarter hours.
💡 The opposite of CEILING.
Try it
Time is billed in quarter hours, rounded down. How many minutes of 52 are billed?
A
B
1
Minutes
Billed
2
52
=FLOOR(A2, 15) rounds down to a multiple of 15.