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.
Need help with Formulas?
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?
When was the TRUNC Function Introduced?
What is the TRUNC Function Used For?
- Truncating a number to a given precision
- Extracting dates from date and time values
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.