Microsoft KB Archive/105744

From BetaArchive Wiki

Mac Works: Rounding to the Nearest Fraction or Percent Value

PSS ID Number: Q105744 Article last modified on 10-22-1998

1.0 1.1 2.0 3.0 4.0

MACINTOSH

======================================================================

The information in this article applies to:

  • == Microsoft Works for the Macintosh, versions 1.x, 2.0, 3.0 and 4.0 ==

SUMMARY

To round a number to the nearest cent value in a Microsoft Works spreadsheet, the following formula can be used:

=INT(Value*100)/100

For example:

When charging sales tax on goods, fractions of a cent are rounded down to the nearest cent. If 7.25 percent sales tax is charged on 15.00, multiplying these two numbers together yields 1.0875, which would round to 1.09. To have Works round this to 1.08, the following formula would be used:

=INT(15.0725100)/100

The returned value will be 1.08.

KBCategory: kbother KBSubcategory: macworkskb

Additional reference words: 1.00 1.10 2.00 3.00 mwksss

====================================================================== Version : 1.0 1.1 2.0 3.0 4.0 Platform : MACINTOSH Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.