Skip to main content

FLOOR

The FLOOR function rounds a number down to the nearest multiple of a specified significance.

Syntax​

=FLOOR(number, significance)

Parameters​

  • number: The number to round down
  • significance: The multiple to round to

Examples​

=FLOOR(3.7, 1) // Returns 3
=FLOOR(3.7, 0.5) // Returns 3.5
=FLOOR(-3.7, -1) // Returns -4