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*.0725*100)/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.