TRUNC

Using the Excel TRUNC Function

Summary

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.

Syntax

=TRUNC (number, [num_digits])

Syntax Breakdown

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

num_digits
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 vs. INT
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.