How to Use Google Sheets TRUNC Function [Difference with INT and ROUND]

Google Sheets TRUNC Function

Google Sheets TRUNC function is all about shortening the number of decimal places. Though you can achieve the same by using Google Sheets Round functions, there are significant difference between TRUNC and ROUND. Also I will introduce you one more function here, i.e. INT.

Unlike Query, Lookup and Logical IFs, there is no need for go deep in to the usage of TRUNC. You can use it out of the box. You may require a little bit explanation at one point. That is how Google Sheets TRUNC formula Differs from ROUND formula.

TRUNC Function Syntax:

TRUNC(value, [places])

Here value is the value to be truncated and the optional places is the number of decimal places to be retained. Take care. Places is not the number of decimal places to be truncated.

Example to Google Sheets Trunc Function

See the below image.

Trunc Function Example

The first Trunc formula retains 2 decimal places and truncate the rest. The next formula retains one decimal places and the third formula truncates all decimal places.

How to Remove Decimal Places in Google Sheets

The last formula in the above example is the answer to your question. That means, to get rid off all decimal places from a number, use the TRUNC formula as below.

= trunc(value)

example: = trunc(1500.12)

Difference Between ROUND and TRUNC Functions in Google Sheets

Both of these functions looks almost similar, right? But it’s not so. Both TRUNC and ROUND function can truncate decimal places in different ways. I can explain you it with one simple example.

Result = 11

Result = 10

In this example, you can clearly understand the difference. While the Round formula rounds up the number on the process of removing the decimal places, Trunc formula only removes the decimal places and retain the number as it is.

Google Sheets INT Function and It’s Difference with TRUNC

INT function Syntax.

Synax: INT(value)

Google Sheets INT function returns only the integer part of a number. It’s equal to TRUNC function at one point.

The formula “TRUNC(Value)” is equal to “INT(Value)”. Both can return the same output. But you can use TRUNC like “TRUNC(value,[places]”. Here you can retain certain number of decimal places, but with INT, it cannot be possible.


Please enter your comment!
Please enter your name here