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

ArgumentRequired?What it does
numberYesThe number to cut.
num_digitsOptionalDecimals to keep. Default 0.

Examples

Example 1 — Chop, don't round

Compare TRUNC with rounding.

B2fx=TRUNC(A2, 1)
AB
1Value1 decimal
28.978.9
3-8.97-8.9
43.141593.1
=TRUNC(A2, 1) Explain

Common mistakes

  • Not the same as INT for negatives. TRUNC(−2.5) = −2; INT(−2.5) = −3.

Notes

Kyle Stott

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.