Skip to main content

FLOOR

Rounds a number down to the nearest multiple of specified significance.

Syntax​

FLOOR(number, significance)

Arguments​

  • number: The numeric value you want to round down.
  • significance: The multiple to which you want to round.

Example​

FLOOR(123.456, 1) → Returns 123
FLOOR(123.456, 0.1) → Returns 123.4
FLOOR(123.456, 10) → Returns 120