How to Remove Decimals in Google Sheets With TRUNC and INT

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 5 min read · includes 2 free exercises

In short: =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

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.

Hint: the second argument is 2.

Exercise 2: Down to an integer

Write a formula that rounds 99.44 down to the nearest integer.

Hint: one argument.

What to learn next

Syntax and rules in this guide were checked against Google's TRUNC/INT help page. See all guides.