 # How To Use TRUNC()

Description

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])`

0Better Sheets Tutorials

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

Numeric Functions 2 Dates

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

Better Sheets