# ROUNDDOWN function in Excel

> ROUNDDOWN always rounds toward zero, dropping the extra digits whatever they are.

Source: https://spreadsheetpractice.com/functions/rounddown · 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:** ROUNDDOWN always rounds toward zero, dropping the extra digits whatever they are.
- **Syntax:** `=ROUNDDOWN(number, num_digits)`
- **Most common use:** `=ROUNDDOWN(B2,1)` returns 7.8 (One decimal: 7.86 becomes 7.8)
- **Available in:** Every current version
- **Category:** [Math functions](https://spreadsheetpractice.com/functions/category/math)
- **Returns:** The number rounded toward zero to the digits you chose.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

ROUNDDOWN always rounds toward zero, dropping the extra digits whatever they are. Use it for counts that must be complete, such as full cases you can ship or whole years of service, and for prices that should never round in the customer's disfavor.

## Syntax

`=ROUNDDOWN(number, num_digits)`

| Argument | Required? | What it is |
|---|---|---|
| `number` | Required | The number or calculation to round down. |
| `num_digits` | Required | How many digits to keep: 0 for whole numbers, 1 for one decimal, -2 for hundreds. |

## Examples

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

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=ROUNDDOWN(B2,1)` | 7.8 | One decimal: 7.86 becomes 7.8 |
| D3 | `=ROUNDDOWN(B3,0)` | 3 | A whole number, even when it's 3.99 |
| D4 | `=ROUNDDOWN(B4,0)` | -4 | Negative numbers move toward zero: -4.75 becomes -4 |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Reading | Value |  | Rounded down |
| 2 | Pressure | 7.86 |  | 7.8 |
| 3 | Age in years | 3.99 |  | 3 |
| 4 | Temperature change | -4.75 |  | -4 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Expected -5 but got -4 | ROUNDDOWN moves toward zero. To always round to the lower number, use INT, which turns -4.75 into -5. |
| Excel says too few arguments | num_digits is required. Use 0 to drop all decimals. |
| A whole number came out one lower | The cell held something like 4.9999 that the format displayed as 5. Round the calculation feeding it, or check the value in the formula bar. |

## Tips

- For whole numbers from positive values, ROUNDDOWN(A2,0), INT(A2) and TRUNC(A2) give the same answer. They differ only for negative numbers.

## Related functions

- [ROUNDUP](https://spreadsheetpractice.com/functions/roundup): ROUNDUP always rounds away from zero, whatever the next digit is.
- [ROUND](https://spreadsheetpractice.com/functions/round): ROUND rounds a number to the number of digits you choose.
- [INT](https://spreadsheetpractice.com/functions/int): INT rounds a number down to the nearest whole number.
- [TRUNC](https://spreadsheetpractice.com/functions/trunc): TRUNC cuts a number off at a set number of decimals without rounding.
- [FLOOR](https://spreadsheetpractice.com/functions/floor): 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.
- Comparison: [ROUND vs ROUNDUP vs ROUNDDOWN](https://spreadsheetpractice.com/functions/compare/round-vs-roundup-vs-rounddown)

## Questions

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

They match for positive numbers. For negatives, ROUNDDOWN goes toward zero (-4.75 to -4) and INT goes to the lower number (-4.75 to -5).

### How do I round down to the nearest hundred?

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

### How do I remove decimals without rounding up?

Use =ROUNDDOWN(A2,0) or =TRUNC(A2). Both drop the decimals without looking at them.

## Practice

A graded ROUNDDOWN exercise ("Full cases to ship") is on [the ROUNDDOWN page](https://spreadsheetpractice.com/functions/rounddown). It is checked instantly, then re-checked on changed data.

Lessons that use ROUNDDOWN:

- [Lesson 33: ROUND, ROUNDUP & ROUNDDOWN](https://spreadsheetpractice.com/learn/round-roundup-rounddown) (Pro)

---

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