Functions
FLOOR.PRECISE
Round down to nearest multiple; sign of significance ignored
Try it
When to use it
When should I use FLOOR.PRECISE instead of FLOOR?
Use FLOOR.PRECISE when the sign of the significance argument should be ignored — it always rounds toward negative infinity regardless of significance sign.
Used in
Syntax
FLOOR.PRECISE(number, [significance])Examples
=FLOOR.PRECISE(-10.5,1) // => -11
=FLOOR.PRECISE(96,10) // => 90
=FLOOR.PRECISE(-23.25,0.1) // => -23.3