Excel: INT() and TRUNC() Work Differently on Negative Numbers

ID: Q50993

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a
Microsoft Excel for the Macintosh, versions 3.0, 4.0

SUMMARY

The two functions TRUNC() and INT() are similar, but return slightly different results for negative numbers. The INT() function rounds a number down to the previous integer. The TRUNC() function simply truncates the decimal portion of a number.

A comparison is described in the chart below.


       Number      INT()     TRUNC()
       ------      -----     -------
        1.5          1          1
        1            1          1
       -1.5         -2         -1
       -1           -1         -1

Additional query words: 1.0 1.00 1.03 1.04 1.06 1.5 1.50 2.0 2.00 2.01 2.1 2.10 2.2 2.20 3.0

Keywords :
Version :
Platform :
Issue type :