TRUNC

Truncates a number to a certain number of significant digits by omitting less significant digits. Learn more

Video field
Math

In Google Sheets, the TRUNC function is used to truncate a number to a specified number of decimal places or integer digits. The function syntax is as follows:

TRUNC(value, [places])

"value" is the number that you want to truncate. [Optional] "places" specifies the number of decimal places (positive) or integer digits (negative) to which you want to truncate the number. If omitted, the function will truncate the number to 0 decimal places. Here's an example to illustrate how to use the TRUNC function:

Suppose you have a value of 3.14159 in cell A1, and you want to truncate it to 2 decimal places. In cell B1, you can use the formula:

=TRUNC(A1, 2)

The TRUNC function will truncate the number in cell A1 to 2 decimal places and return the result in cell B1. In this case, the result would be 3.14.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!