# FLOOR function in Excel

> FLOOR rounds a number down to the previous multiple you choose: down to the nearest 10, the nearest quarter, or the start of a price band.

Source: https://spreadsheetpractice.com/functions/floor · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** FLOOR rounds a number down to the previous multiple you choose: down to the nearest 10, the nearest quarter, or the start of a price band.
- **Syntax:** `=FLOOR(number, [significance])`
- **Most common use:** `=FLOOR(B2,10)` returns 30 (Down to the multiple of 10 below: 37 becomes 30)
- **Available in:** Every current version
- **Category:** [Math functions](https://spreadsheetpractice.com/functions/category/math)
- **Returns:** The largest multiple of significance that is no more than number. Negative numbers round away from zero.

## What it does

FLOOR rounds a number down to the previous multiple you choose: down to the nearest 10, the nearest quarter, or the start of a price band. It's the mirror of CEILING and is useful for grouping values into brackets.

## Syntax

`=FLOOR(number, [significance])`

| Argument | Required? | What it is |
|---|---|---|
| `number` | Required | The value to round down. |
| `significance` | Optional | The multiple to round down to, such as 10 or 0.25. Excel requires it in FLOOR; FLOOR.MATH makes it optional. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=FLOOR(B2,10)` | 30 | Down to the multiple of 10 below: 37 becomes 30 |
| D3 | `=FLOOR(B3,0.25)` | 4.75 | Down to the quarter: 4.87 hours becomes 4.75 |
| D4 | `=FLOOR(B4,2)` | -4 | Negative numbers move away from zero: -2.5 becomes -4 |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Item | Amount |  | Rounded down |
| 2 | Order size | 37 |  | 30 |
| 3 | Hours logged | 4.87 |  | 4.75 |
| 4 | Adjustment | -2.5 |  | -4 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| #NUM! | number is positive but significance is negative, such as =FLOOR(25,-5). Use a positive significance. |
| Excel says too few arguments | FLOOR needs significance. Use =FLOOR(A2,1) for whole numbers, or FLOOR.MATH(A2), where it's optional. |
| -2.5 became -4, not -2 | For negative numbers FLOOR rounds down, away from zero. Use TRUNC or ROUNDDOWN to move toward zero instead. |

## Tips

- Group values into bands for a summary: =FLOOR(B2,100) puts 0–99 in band 0, 100–199 in band 100, and so on.

## Related functions

- [CEILING](https://spreadsheetpractice.com/functions/ceiling): CEILING rounds a number up to the next multiple you choose: the next 5, the next dozen, the next quarter hour.
- [ROUNDDOWN](https://spreadsheetpractice.com/functions/rounddown): ROUNDDOWN always rounds toward zero, dropping the extra digits whatever they are.
- [INT](https://spreadsheetpractice.com/functions/int): INT rounds a number down to the nearest whole number.
- [MROUND](https://spreadsheetpractice.com/functions/mround): MROUND rounds a number to the nearest multiple of another number.

## Questions

### How do I round down to the nearest 10 in Excel?

Use =FLOOR(A2,10) or =ROUNDDOWN(A2,-1).

### How do I round a time down to the hour?

Use =FLOOR(A2,"1:00") and format the result as a time.

### What is the difference between FLOOR and INT?

INT always rounds down to a whole number. FLOOR rounds down to any multiple you choose.

## Practice

A graded FLOOR exercise ("Price break quantity") is on [the FLOOR page](https://spreadsheetpractice.com/functions/floor). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
