What is the Excel TRUNC Function?
Excel TRUNC function truncates a number by removing the fractional part of the number based on a number_digits argument.
TRUNC Syntax
TRUNC(number, [num_digits])
number, required, the number to be truncated.
num_digits, optional, a number specifying the precision of the truncation. The default value is 0 (zero).
Usage notes:
- Use the TRUNC function to cut a set number of decimal places without rounding.
- The TRUNC function without the num_digits argument is like the INT function for positive numbers, both returns integer number from a number. For negative numbers, both return a different number. The TRUNC function does not round, only cuts numbers based on the num_digit argument, while the INT function does To get an integer number from a number, whether positive or negative, use the TRUNC function without the num_digits argument.
How to Use TRUNC Function in Excel
Next is the TRUNC function which is used to cut the number 123.456 with positive or negative signs. What are the results when using different num_digits arguments?
TRUNC Function #1
=TRUNC(123.456)
The TRUNC function without the num_digits argument, by default Excel uses the number 0. As a result, Excel cuts all the numbers behind the decimal separator, leaving only the integer numbers.
The result is 123.
TRUNC Function #2
=TRUNC(123.456,2)
TRUNC function with num_digits argument 2. Excel cuts numbers behind the decimal separator and leaves two-digit numbers.
The result is 123.45
TRUNC Function #3
=TRUNC(123.456,4)
If the number of digits behind the decimal separator is smaller than the num_digits argument, Excel does not cut any numbers.
The result is the same as the original number 123.456.
TRUNC Function #4
=TRUNC(123.456,-2)
If the argument num_digits is negative, excel cuts all the numbers behind the decimal separator and changes the number in front of the decimal separator to 0. The number of numbers changed depends on the num_digits argument.
The result is 100.
TRUNC Function #5
=TRUNC(-123.456)
The TRUNC function with the negative number argument and without the num_digits argument. The result remains the same negative number without numbers behind the decimal separator.
The result is -123.
TRUNC Function #6
=TRUNC(-123.456,2)
The TRUNC function with a negative number argument and positive num_digit argument. The result is -123.45
TRUNC Function #7
=TRUNC(-123.456,-2)
The TRUNC function with a negative number argument and num_digit argument.
The result is a negative integer number with two-digit numbers in front of the decimal separator changing to zero. The result is -100.
Please see the results of all the excel TRUNC functions above in the picture below.
