TRUNC
Math & Trig
Truncates a number to an integer by removing the decimal part.
Translations
EnglishTRUNC
FrenchTRONQUE
SpanishTRUNCAR
GermanKÜRZEN
ItalianTRONCA
PortugueseTRUNCAR
DutchGEHEEL
PolishLICZBA.CAŁK
RussianОТБР
TurkishNSAT
CzechUSEKNOUT
HungarianCSONK
SwedishAVKORTA
DanishAFKORT
FinnishKATKAISE
Syntax
TRUNC(number, [num_digits])Arguments
numberThe number to truncatenum_digitsPrecision (default 0)(optional)
Examples
=TRUNC(8.9)8
Removes decimal part
=TRUNC(-8.9)-8
Truncates toward zero
=TRUNC(3.14159,2)3.14
Keeps 2 decimal places
Tips & Best Practices
- •Does not round, just removes decimals
- •Different from INT for negative numbers
- •TRUNC(-8.9)=-8 but INT(-8.9)=-9
Common Mistakes
- •Confusing TRUNC with ROUND - TRUNC simply cuts off the decimal portion without any rounding logic, so TRUNC(4.9) returns 4, not 5
- •Forgetting that TRUNC's second argument controls decimal places kept, not just whole-number truncation - TRUNC(3.14159,2) returns 3.14, not 3
- •Using TRUNC on a negative number expecting it to round away from zero like some rounding conventions - TRUNC always cuts toward zero, so TRUNC(-4.9) returns -4, not -5
Related Functions
INTAlways rounds down toward negative infinity, behaving identically to TRUNC for positive numbers but differently for negative ones.ROUNDRounds to the nearest value using standard rounding rules, rather than simply cutting off digits like TRUNC.MROUNDRounds to the nearest multiple of a specified value, a different kind of precision control than TRUNC's digit-cutting.Frequently Asked Questions
What's the difference between TRUNC and INT?
For positive numbers, they're identical. For negative numbers, TRUNC cuts toward zero while INT always rounds down (more negative). TRUNC(-4.9) gives -4, INT(-4.9) gives -5.
Does TRUNC round numbers?
No, it simply removes digits beyond the specified precision without any rounding logic - TRUNC(4.9) returns 4, not 5.
How do I keep a specific number of decimal places with TRUNC?
Use the second argument, like TRUNC(3.14159,2), which returns 3.14 by cutting off everything after two decimal places.
Need to translate a formula using TRUNC?
Use our translator to convert your complete formula