TRUNC Function – Google Sheets

The TRUNC function in Google Sheets removes unwanted digits from a number.

This function can simplify large numbers or convert decimal values to integers. You can also use it to filter data in a spreadsheet.

⚠️ The TRUNC function is similar to the INT function, but TRUNC accepts a place argument and treats negative numbers differently (see example 2).


The syntax for the TRUNC function is:

=TRUNC(value, [places])

value – The number that you want to truncate.

places – An optional argument specifying the number of digits.

Similar Functions

Several functions deal with rounding. Choose the most appropriate for your use.

  • CEILING – Rounds a number up to the nearest integer multiple of specified significance
  • INT – Rounds a number down to the nearest integer
  • FLOOR – Rounds a number down to the nearest integer multiple of specified significance
  • MROUND – Rounds one number to the nearest integer multiple of another
  • ROUND – Round a number to a specified number of decimal places using standard rounding
  • ROUNDDOWN – Round a number down to a specified number of places
  • ROUNDUP – Round a number up to a specified number of places
  • TRUNC: Truncates a number to a certain number of significant digits by omitting less significant digits

Possible Errors

#VALUE! – An argument is non-numeric.

Insert Math Symbols (Add-On)

Web banner showing math symbols from the Insert Special Characters Add-On
Explain Your Formulas with Symbols

TRUNC Function Examples

Here are some examples of how you can use the TRUNC function in Google Sheets:

Example 1 – Lower a Decimal to a Whole Number

To change the number 12.345 to 12, you would use the following formula:


As you can see from the result of 12, TRUNC does not follow standard rounding rules. It simply removes numbers to arrive at the number of places specified. In this case, places defaulted to 0. We’ve seen this work with a positive number. Next, let’s look at a negative number.

Example 2 – Negative Number

Next, let’s look at using TRUNC on a negative number. We’ll switch the sign to -12.345 and keep the places argument at the default of 0.


The result is -12. It is essential to realize this is a different result than rounding a number with the INT function, which would have returned -13.

Example 3 – Filtering by Numbers

You can use this function to FILTER data in a spreadsheet. For example, the following formula would return all of the rows in a spreadsheet where the value in the Price column is an integer:

The TRUNC and FILTER functions creating for integers
Using the TRUNC Function to Filter Values

Formula used: =FILTER(A4:B7, TRUNC(B4:B7) = B4:B7)

The filter returns rows where the truncated number is the same as the original. The values only meet this condition when they have no decimal values.

Example 4 – Similarity to the ROUNDDOWN Function

Google Sheets offers many functions to handle rounding. One of them ROUNDDOWN, functions the same as the TRUNC function. Let’s look at a few values and places to show how the output compares.

A table showing the TRUNC and ROUNDDOWN functions producing the same outputs

As you can see, the two functions output the same results.

Live Examples in Google Sheets

Use a copy of this live Google Sheet for a quick start with the examples from above.


The TRUNC function in Google Sheets helps remove decimal places from numbers. This function can make numbers easier to read and understand or work with in calculations.

Leave a Comment