All functions / Math

FLOOR.MATH

Rounds a number down to the nearest multiple; mode rounds negative numbers toward zero.

Syntax

=FLOOR.MATH(number, [significance], [mode])

Arguments

• number: The number to use.
• significance (optional): The multiple to round to (default 1; its sign is ignored).
• mode (optional): For negative numbers: 0 rounds away from zero, anything else toward it.

Example

=FLOOR.MATH(-5.5, 2) → -6

Also written as FLOOR.PRECISE.