Excel Function : FLOOR

Download now!

Excel Function : FLOOR

Category

Compatibility

Description

Rounds a number down, toward zero

Microsoft Excel Reference Page

https://support.office.com/en-us/article/FLOOR-function-14bb497c-24f2-4e04-b327-b0b4de5a8886

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.