How to Remove Decimals in Google Sheets With TRUNC and INT
=TRUNC(value, [places]) discards digits without rounding. =INT(value) rounds down to the nearest integer. They agree for positive numbers and differ for negative ones.
Two ways to drop decimals
Sometimes you want the whole-number part of a value, not a rounded one. TRUNC and INT both do that, but they treat negative numbers differently. For ordinary rounding see ROUND, and for one-direction rounding see ROUNDUP and ROUNDDOWN.
Syntax
=TRUNC(value, [places])
=INT(value)
Per Google's help pages, TRUNC takes the number and an optional places, which defaults to 0 and sets how many digits to keep right of the decimal point. A negative places zeroes digits to the left of the decimal point. The page states that TRUNC performs no rounding and simply discards unwanted digits. INT takes one value and rounds it down to the nearest integer that is less than or equal to it.
A step-by-step example
=TRUNC(3.141592654, 2)
This returns 3.14. The remaining digits are simply dropped, with no rounding. Compare with INT:
=INT(99.44)
This returns 99, as in Google's own sample.
Where they differ: negative numbers
INT always moves to the smaller integer, so INT(-1.5) is -2, because -2 is the nearest integer that is less than or equal to -1.5. TRUNC just removes the digits, so TRUNC(-1.5) is -1. The INT help page notes the same split: INT differs from ROUNDDOWN with places 0 for negative numbers, because INT works from the signed value while ROUNDDOWN works from the absolute value.
Common mistakes
- Expecting rounding. Neither function rounds to the nearest.
- Using INT on negatives and expecting TRUNC's result.
- Forgetting places. TRUNC without it removes all decimals.
Try it yourself
Type your formula into the box, starting with =, then press Check.
Exercise 1: Keep two decimals
Write a formula that cuts 3.141592654 to two decimal places without rounding.
Exercise 2: Down to an integer
Write a formula that rounds 99.44 down to the nearest integer.
What to learn next
- ABS: the size of a number, ignoring its sign.
- ROUND: round numbers to any number of places.
- ROUNDUP and ROUNDDOWN: always round up or always round down.
Syntax and rules in this guide were checked against Google's TRUNC/INT help page. See all guides.