# How to round down to a multiple in Excel (FLOOR)

Use FLOOR with the step: `=FLOOR(B2,C2)` rounds 1,375 down to 1,320 when pallets hold 60.

**Excel:** `=FLOOR(B2,C2)` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D |
| --- | --- | --- | --- |
| Item | Units in stock | Units per pallet | Units on full pallets |
| Cement bags | 1375 | 60 |  |
| Pavers | 2210 | 250 |  |
| Mulch bags | 488 | 40 |  |
| Bricks | 5000 | 500 |  |
| Gravel bags | 95 | 48 |  |

Formula in D2, filled to D6: `=FLOOR(B2,C2)`

Result: 1,320; 2,000; 480; 5,000; 48

## How it works

FLOOR rounds down to the last multiple of its second argument that fits: 22 full pallets of 60 is 1,320, and the other 55 bags don't make a pallet. Values that are already multiples, like 5,000, stay the same.

## Other ways

- `=FLOOR.MATH(B2,C2)`: The newer function, with a mode argument for negative numbers.
- `=B2-MOD(B2,C2)`: Subtract the remainder; the same result for positive numbers in any app.

## Common mistakes

- For negative numbers, FLOOR rounds away from zero (-7 becomes -10 with a step of 5). Check what your report needs.
- FLOOR returns #DIV/0! or 0 when the step is 0 or blank. Make sure every row has a step.

## Questions

**How many full pallets is that?**

Use `=INT(B2/C2)`, or `=ROUNDDOWN(B2/C2,0)`.

**How do I round down to the nearest 100?**

Use `=FLOOR(B2,100)` or `=ROUNDDOWN(B2,-2)`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/round-down-to-a-multiple