Article updated on January 30, 2018

Rounds 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.