Excel TRUNC Function

Using the Excel TRUNC Function


Excel's TRUNC function removes the fractional part of a number and returns only the integer. The TRUNC and INT functions are similar in that both return integers. The difference is in how the fractional portion of the number is handled. TRUNC simply removes the fraction, while INT rounds the number down to the nearest integer based on the value of the fraction. For example, given -5.8 TRUNC will return -5 while INT returns -6.


=TRUNC (number, [num_digits])

Syntax Breakdown

The number argument is required in the TRUNC function and is the number that you want to truncate.

The num_digits argument is optional. This is a number specifying the precision of the truncation. Default is zero (0).

Usage Notes

The TRUNC function is used to return the integer portion of a number without performing any rounding. For example, =TRUNC(6.9) will return 6. It is possible to specify a set number of decimal numbers to be returned without rounding via the optional num_digits argument.

TRUNC and INT both return the integer portion of a number. They differ in how the fraction is handled. TRUNC does not round while INT will round the number down to the nearest integer. When working with positive numbers, and when TRUNC's num_digits argument is zero (0), the two functions will return the same result.

TRUNC vs INT Positive Numbers

The functions begin to return different results when negative numbers are entered.

TRUNC vs INT Negative Numbers

If you require only the integer portion of a number, use TRUNC. If you require a number to be rounded down to the nearest integer, then use INT.