Skip to content

How to Chop Off Decimals in Google Sheets

In this article, I will show you how to use the TRUNC function to chop off a specified number of decimals from a selected number.

The TRUNC Function

The TRUNC function in Google Sheets allows you to remove a specified number of decimals from any number.

It is important to note that the TRUNC function does not round the number. It simply removes unwanted decimals.

How to Use It

The TRUNC function accepts two arguments.

  • The first argument can be a number or reference to a cell containing a number.
  • The second argument is a number specifying how many decimals should remain. This argument is optional and defaults to zero.

Example 1 – No Decimals

Take the original number in cell B1.

Enter the following formula to remove all decimals from the original number.

=TRUNC(B1)

The TRUNC function references the number in cell B1 and removes all the decimals.

Example 2 – Two Decimals

Take the original number in cell B1.

Enter the following formula to remove all but the first two decimals from the original number.

=TRUNC(B1, 2)

The TRUNC function references the number in cell B1 and leaves only the first two decimals due to the two as the second argument.

Note that the TRUNC function does not round the original number. It simply removes all decimals after the first two. Check out this article to learn how to round.

And that is how you can use the TRUNC function to chop off decimals in Google Sheets.

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top