Article updated on April 14, 2018

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

Excel Function Syntax

FLOOR(number, significance)

Arguments

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