All functions / Math

FLOOR

Rounds a number down to the nearest multiple (toward zero when both are negative).

Syntax

=FLOOR(number, [significance])

Arguments

• number: The number to use.
• significance (optional): The multiple to round to (default 1).

Example

=FLOOR(23, 5) → 20