# FLOOR

### Definition of FLOOR

### Sample Usage

`FLOOR(23.25,0.1)`

`FLOOR(A2,1)`

### Syntax

`FLOOR(value, [factor])`

`value`

- The value to round down to the nearest integer multiple of`factor`

.`factor`

-**[**OPTIONAL -`1`

by default**]**- The number to whose multiples`value`

will be rounded.`factor`

may not be equal to`0`

.

### Notes

`value`

and`factor`

must have the same sign; that is, they must both be positive or both negative.`FLOOR`

is most often used with`factor`

set to a 'round' number such as`0.1`

or`0.01`

in order to round to a particular decimal place. However,`factor`

can, in fact, be any number of the same sign as`value`

, e.g.`FLOOR(23.25,0.18)`

which results in`23.22`

, which is 0.18 * 129. This can be used, for instance, to round down to a particular denomination of currency (e.g. 0.25 or 0.05 USD).

### See Also

`CEILING`

: Rounds a number up to the nearest integer multiple of specified significance.

`TRUNC`

: Truncates a number to a certain number of significant digits by omitting less significant digits.

`ROUNDUP`

: Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.

`ROUNDDOWN`

: Rounds a number to a certain number of decimal places, always rounding down to the next valid increment.

`ROUND`

: Rounds a number to a certain number of decimal places according to standard rules.

`MROUND`

: Rounds one number to the nearest integer multiple of another.

`INT`

: Rounds a number down to the nearest integer that is less than or equal to it.

### In order to use the FLOOR formula, start with your edited Excellentable

### Then type in the Floor Formula in the area you would like to display the outcome:

### Type in the complete Floor formula for a cell as shown below:

### Excellentable will generate the outcome when hitting enter.