# TRUNC function in Excel

> TRUNC cuts a number off at a set number of decimals without rounding.

Source: https://spreadsheetpractice.com/functions/trunc · 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:** TRUNC cuts a number off at a set number of decimals without rounding.
- **Syntax:** `=TRUNC(number, [num_digits])`
- **Most common use:** `=TRUNC(B2)` returns 8 (Drops the decimals without rounding: 8)
- **Available in:** Every current version
- **Category:** [Math functions](https://spreadsheetpractice.com/functions/category/math)
- **Returns:** The number with the extra digits removed, not rounded.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

TRUNC cuts a number off at a set number of decimals without rounding. 8.97 becomes 8, and with two digits 3.14159 becomes 3.14. Unlike INT, it moves negative numbers toward zero, so -8.97 becomes -8.

## Syntax

`=TRUNC(number, [num_digits])`

| Argument | Required? | What it is |
|---|---|---|
| `number` | Required | The number to cut off. |
| `num_digits` | Optional | How many decimals to keep. Leave it out (or use 0) to keep none. |

## Examples

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

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| C2 | `=TRUNC(B2)` | 8 | Drops the decimals without rounding: 8 |
| C3 | `=TRUNC(B3)` | -8 | Negative numbers move toward zero: -8, where INT gives -9 |
| C4 | `=TRUNC(B4,2)` | 3.14 | Keeps two decimals and cuts the rest: 3.14 |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C |
|---|---|---|---|
| 1 | Value | Number |  |
| 2 | Price | 8.97 | 8 |
| 3 | Loss | -8.97 | -8 |
| 4 | Pi | 3.14159 | 3.14 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Expected 2.999 to become 3 | TRUNC never rounds. Use ROUND when you want the nearest value. |
| Different results from INT | They only differ for negative numbers: TRUNC(-3.7) is -3 and INT(-3.7) is -4. Pick the one that matches your rule. |
| #VALUE! | The number is text that can't be read as a number. Clean the source cell or wrap it in VALUE. |

## Tips

- Negative num_digits cuts to the left of the decimal: =TRUNC(1987,-2) returns 1900.

## Related functions

- [INT](https://spreadsheetpractice.com/functions/int): INT rounds a number down to the nearest whole number.
- [ROUNDDOWN](https://spreadsheetpractice.com/functions/rounddown): ROUNDDOWN always rounds toward zero, dropping the extra digits whatever they are.
- [ROUND](https://spreadsheetpractice.com/functions/round): ROUND rounds a number to the number of digits you choose.

## Questions

### What is the difference between TRUNC and INT in Excel?

For positive numbers, nothing. For negatives, TRUNC goes toward zero (-3.7 to -3) and INT goes down (-3.7 to -4).

### How do I truncate to two decimal places?

Use =TRUNC(A2,2). 4.567 becomes 4.56.

### Is TRUNC the same as ROUNDDOWN?

Yes, in results: both cut toward zero. ROUNDDOWN requires the digits argument, while TRUNC defaults to 0.

## Practice

A graded TRUNC exercise ("Commission to the cent") is on [the TRUNC page](https://spreadsheetpractice.com/functions/trunc). 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.
