Microsoft KB Archive/50993

{|
 * width="100%"|

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 :