Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/92585

From BetaArchive Wiki

Excel: TRUNC() Function Not Described Clearly in Manual

The information in this article applies to:

  • Microsoft Excel for Windows, versions 3.0, 4.0
  • Microsoft Excel for the Macintosh, versions 3.0, 4.0


On page 438 of the version 4.0 "Microsoft Excel Function Reference," and pages 239-240 of the version 3.0 "Microsoft Excel Function Reference," the description for the TRUNC() function reads

   Truncates a number to an integer by removing the fractional part of
   the number. 

A more accurate description is

   Truncates a number to the precision specified in num_digits by
   removing the remaining fractional part. If num_digits is zero or
   blank, truncates the number to an integer by removing the entire
   fractional part. 

For example, TRUNC(8.932,2) returns 8.93, but TRUNC(8.932) returns 8.


"Microsoft Excel Function Reference," version 4.0, 438

"Microsoft Excel Function Reference," version 3.0, 239-240

Additional query words: 3.0 results incorrect truncation truncate

Keywords :
Version :
Platform :
Issue type :
Technology :

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