Microsoft KB Archive/50993

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 17:57, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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



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 :
Technology :


Last Reviewed: March 15, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.