TRUNC Function in Google Sheets

  • Reading time:2 mins read
  • Post category:Functions
  • Post comments:0 Comments

TRUNC Function truncates a decimal number to a certain number of significant digits. Say like converting 12.365 to 12.3 or 10.5322 to 10.53

This is a very useful function if your are just looking to limit no of digits after decimal places and not to round off specifically. Lets cover all the necessary components and gain complete understanding of dynamics of TRUNC Function.

Purpose of TRUNC Function

Google defines TRUNC Function as “Truncates a number to a certain number of significant digits by omitting less significant digits“. And this is exactly what it does as well.

To use it simply type “=TRUNC(” place the number within and close the bracket. Another ways is to click on the function dropdown in the Toolbar.

TRUNC Function

Syntax and Parameter Definition

=TRUNC(value, [places])
  1. value: The number you want to Truncate
  2. [places]: The number of digits to the right of decimal, you want to retain.

Note:

  1. TRUNC Function only accepts numerical input.
  2. Any form of non-numerical input(like “abc”, “xyz” etc) will result in an “#VALUE!” error.
  3. TRUNC doesn’t perform any rounding operation like ROUND/CEIL/FLOOR. It simply retains the number of decimal places as told to and deletes the rest

Expected Output

TRUNC Function retains the specified number of digits post decimal place and deletes the rest. Below are some examples to help understand the function better.

TRUNC Function - Google Sheets

From first two examples it’s pretty clear that TRUNC simply keeps 2 digits post decimal and deletes the rest. Also, there is no impact of number being positive or negative.

In the third example we are left with 15.5 since we specificed the [places] argument to be 1.

Example 4 & 5, though have similar outputs, but have different formula’s. In 5, even though we didn’t specify the anything, we ended up with a similar result since the default value of [places] is 0.

Visual Demonstration of INT

Before we end here is a simple visual demonstration of TRUNC Function

TRUNC Function - Video Tutorial

That’s it on this topic. Keep browsing SheetsInfo for more such useful information 🙂

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Liked the content?? Then share the word!!!

Rishav

I love Google Sheets and heavily rely upon it on a day to day basis. SheetsInfo is my attempt to share my learning with all of you. Hope you find the articles easy to read and simple to understand.

Leave a Reply