Formulas > =TRUNC()

How To Use TRUNC() Function in Google Sheets


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

Common questions about the TRUNC formula include:
1. What does the TRUNC function do?
2. How is the TRUNC formula written?

The TRUNC formula can be appropriately used to truncate the value of a number to a certain length or decimal place.

The TRUNC formula can be commonly mistyped by missing a comma between the two arguments, or by writing TRUNK instead of TRUNC.

Some common ways that the TRUNC formula is used inappropriately include:
1. Confusing the TRUNC formula with the ROUND formula, which is used to round numbers rather than truncate them.
2. Trying to use the TRUNC formula on a non-numeric value.

Common pitfalls when using the TRUNC formula include:
1. Forgetting the second argument that indicates the number of decimal places.
2. Passing too large of a second argument which causes the output to truncate more numbers than expected.

Common mistakes when using the TRUNC Formula include:
1. Forgetting to include the number of decimal places as a second argument.
2. Forgetting to include a comma between the two arguments.

Common misconceptions people might have with the TRUNC Formula include:
1. Thinking that the TRUNC function will round the number rather than just truncate it.
2. Thinking that the TRUNC function can be used on non-numeric values.

How To Actually Use TRUNC() in Sheets

TRUNC(value, [places])

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the TRUNC() formula:

Numeric Functions 2 Dates

How to manipulate dates, calculate periods between dates in Google Sheets

Generate a TRUNC() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.