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.

The `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.

For example:

```
=TRUNC(123.456,2)
=TRUNC(123.4357,-1)
=TRUNC(-123.123)
=INT(567.89)
=INT(-567.89)
```

Will display:

```
123.45
120.00
-123.00
567.00
-568.00
```

This modified text is an extract of the original Stack Overflow Documentation created by following contributors and released under CC BY-SA 3.0

This website is not affiliated with Stack Overflow