Author: Oscar Cronquist Article last updated on May 04, 2022

The FLOOR function rounds a number down, toward zero, to the nearest multiple of significance.

1. FLOOR Function Syntax

FLOOR(number, significance)

Back to top

2. FLOOR Function Arguments

number Required. The number you want to round.
significance Required. The multiple to which you want to round.

Back to top

3. FLOOR Function Example

Formula in cell C3:

=FLOOR(B3, 2)

Back to top