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 |
