## How to use the FLOOR function

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

### Functions in 'Compatibility'

The FLOOR function function is one of many functions in the 'Compatibility' category.

The CONFIDENCE function calculates the confidence interval for a population mean, using a normal distribution. Formula in cell B6: =CONFIDENCE(B3, […]

The FLOOR function rounds a number down, toward zero, to the nearest multiple of significance. Excel Function Syntax FLOOR(number, significance) Arguments […]

The MODE function calculates the most frequent number in a cell range. Number 4 exists 3 times on picture above […]

The RANK function calculates the rank of a specific number compared to a list of numbers. Formula in cell C3: […]

The STDEV function calculates the standard deviation of a group of values. Standard deviation shows how much the values differ from the […]