Mac Works: Rounding to a Set Limit
PSS ID Number: Q24719 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.x, 3.x and 4.0 |
SUMMARY
In a Microsoft Works spreadsheet, to round a number to a set limit (for example, to the nearest .05), use the following formula:
=ROUND(value1(1/value2),0)value2
MORE INFORMATION
In the above formula, “value1” is the value (or reference of the value) to be rounded, and “value2” is the value to round to. For example, if value1 = 14.37 and value2 = .05, the result would be 14.35.
KBCategory: kbusage KBSubcategory: macworkskb
Additional reference words: 1.00 1.10 2.0 3.0 4.0 mwksss
Version : 1.0 1.1 2.0 3.0 4.0 Platform : MACINTOSH Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.