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.
