# TRUNC

Formulas / TRUNC
"Truncate a number to a specified precision."
`TRUNC(number, [num_digits])`
• number - required, the number to truncate
• num_digits - [OPTIONAL] specifies the precision of the truncation

## Examples

• `TRUNC(4.9)`

The TRUNC function is used to truncate a number to a specified number of decimal places. For example, this returns 4, which truncates the number 4.9 to the integer 4.

• `TRUNC(-3.5, 1)`

In the example, the TRUNC function is used to truncate the number -3.5 to one decimal place. This returns -3.5, which truncates the number to one decimal place.

• `TRUNC(3.141593,2)`

In the example, the TRUNC function is used to truncate the number 3.141593 to two decimal places. This returns 3.14, which truncates the number to two decimal places.

• `TRUNC(3.141593,0)`

In the example, the TRUNC function is used to truncate the number 3.141593 to zero decimal places. This returns 3, which truncates the number to zero decimal places.

## Summary

The TRUNC function is a useful tool for removing the decimal part of a number, truncating it to an integer value. It can also be used to extract dates from date and time values and was introduced in MS Excel 2007. It can be used to truncate a number to a given precision.

• The TRUNC function takes two arguments: number (required) and num_digits (optional).
• The TRUNC function truncates a number to a certain length by removing the decimal part of the number.

## Frequently Asked Questions

What is the TRUNC Function?
The TRUNC function is a Sourcetable function that removes the fractional part of a number, truncating it to an integer value.
When was the TRUNC Function Introduced?
The TRUNC function was introduced in Microsoft Excel 2007.
What is the TRUNC Function Used For?
The TRUNC function is useful for:
• Truncating a number to a given precision
• Extracting dates from date and time values