TRUNC Function
Cuts a number off at a set number of decimals, without rounding.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
A number
Want to practice TRUNC in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
TRUNC simply chops off digits. TRUNC(8.97) is 8 and TRUNC(−8.97) is −8 — no rounding in either direction.
Use it when you want the whole part of a number regardless of sign.
Syntax
=TRUNC(number, [num_digits])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The number to cut. |
| num_digits | Optional | Decimals to keep. Default 0. |
Examples
Example 1 — Chop, don't round
Compare TRUNC with rounding.
B2fx=TRUNC(A2, 1)
| A | B | |
|---|---|---|
| 1 | Value | 1 decimal |
| 2 | 8.97 | 8.9 |
| 3 | -8.97 | -8.9 |
| 4 | 3.14159 | 3.1 |
=TRUNC(A2, 1) Explain
Common mistakes
- Not the same as INT for negatives. TRUNC(−2.5) = −2; INT(−2.5) = −3.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.