Excel function · Statistics
FLOOR
Rounds a number down to the previous multiple of another.
What it does
FLOOR rounds down to the nearest multiple of the number you choose. It suits billing in whole blocks and counting only complete packs.
Syntax
=FLOOR(number, significance)Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ,
Arguments
- number
- The number to round down.
- significance
- The multiple to round to, such as 15 or 0.5.
Example
Time is billed in completed 15-minute blocks. How many minutes are billed for 52 minutes of work?
| A | B | |
|---|---|---|
| 1 | Minutes | Billed |
| 2 | 52 | 45 |
The formula in B2:
=FLOOR(A2,15)Result: 45
The multiples of 15 are 15, 30, 45, 60. The last one that doesn't exceed 52 is 45.
Common mistakes
- Mixing it up with
CEILING.FLOORalways goes down, even for 59 minutes. - Giving a negative number with a positive multiple in older versions, which gives
#NUM!.
In other Excel languages
Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.
| Excel language | Function name | Separator |
|---|---|---|
| English | FLOOR | , |
| Deutsch | UNTERGRENZE | ; |
| Français | PLANCHER | ; |
| Español (España) | MULTIPLO.INFERIOR | ; |
| Español (México) | MULTIPLO.INFERIOR | , |
| 日本語 | FLOOR | , |
| 한국어 | FLOOR | , |
| 繁體中文 | FLOOR | , |
| ไทย | FLOOR | , |
| ខ្មែរ | FLOOR | , |
| Tiếng Việt | FLOOR | ; |