# 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).

## SYNTAX

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.

## 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:

`=TRUNC(12.345)`

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.

`=TRUNC(-12.345)`

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:

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.