Author: Oscar Cronquist Article last updated on May 04, 2022

The TRUNC function removes the fractional part of the number to an integer.

Formula in cell C3:


Excel Function Syntax

TRUNC(number, [num_digits])


number Required. The number you want to truncate.
[num_digits] Optional. A number specifying the precision of the truncation. If omitted 0 (zero) is used.


INT and TRUNC both returns integers, however, they are only different when it comes to negative numbers. INT(-10.3) returns -11 and TRUNC(-10.3) returns -10.

How to use the INT function

The INT function removes the decimal part from positive numbers and returns the whole number (integer) except negative values are […]

How to use the INT function