The excel formula
TRUNC is used to truncate a number to a given number of decimal places, specified by the optional
num_digits parameter. If this parameter is defined as a negative value it will truncate the integer portion of the value. If the parameter is omitted then the default value is
0 which removes the decimal portion of the number.
INT function works in a smilar way to
TRUNC in that it removes the decimal portion of a number by rounding it down to leave the integer portion. The difference between the two is when performing the operation on a negative number;
TRUNC will strip the decimal, however
INT will round the value down away from zero.
=TRUNC(123.456,2) =TRUNC(123.4357,-1) =TRUNC(-123.123) =INT(567.89) =INT(-567.89)
123.45 120.00 -123.00 567.00 -568.00