Excel Function : FLOOR

Download now!

Excel Function : FLOOR




Rounds a number down, toward zero

Microsoft Excel Reference Page


Syntax and Description of the FLOOR Excel Function

The syntax for the FLOOR function in Microsoft Excel is: FLOOR( number, significance ) where the number argument is the value to round, and the significance argument is the multiple to which you want to round the number.

About FLOOR Excel Function

FLOOR(number,significance) The FLOOR function rounds a number down to the nearest multiple of significance.