Functions
FLOOR.MATH
Round down to nearest multiple; handles negative numbers via mode
Try it
When to use it
When should I use FLOOR.MATH instead of FLOOR?
Use FLOOR.MATH when you need configurable rounding direction for negative numbers — the mode argument lets you round toward zero instead of away from it.
Used in
Syntax
FLOOR.MATH(number, [significance], [mode])Examples
=FLOOR.MATH(11.2) // => 11
=FLOOR.MATH(-8.8) // => -9
=FLOOR.MATH(7.7,0.2) // => 7.6000000000000005