Author: Oscar Cronquist Article last updated on June 20, 2018

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

Formula in cell C3:

=TRUNC(B3)

Excel Function Syntax

TRUNC(number, [num_digits])

Arguments

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.

Comments

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

Removes the decimal part from positive numbers and returns the whole number (integer) except negative values are rounded down to […]

How to use the INT function