FLOOR

Try it

When to use it

When should I use FLOOR instead of ROUNDDOWN?

FLOOR rounds down to the nearest multiple of a factor you choose, such as the previous 25 or 0.05. ROUNDDOWN only rounds down to decimal places. Use FLOOR for packaging units, price bands, or time buckets.

How do I round a value down to the nearest 15 minutes expressed in hours?

Use FLOOR with the factor for 15 minutes. For decimal hours that is FLOOR(hours, 0.25), which snaps down to the previous quarter hour.

Use cases

Round a count down to full pallets of 25

Round a price down to the nearest 5 cents

Used in

operations · engineering

Syntax

FLOOR(number, significance)

Examples

=FLOOR(23.25,0.1) // => 23.200000000000003
=FLOOR(23.25,1) // => 23
=FLOOR(23.25,0.18) // => 23.22