Microsoft KB Archive/24719: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (X010 moved page Microsoft KB Archive/Q24719 to Microsoft KB Archive/24719 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/") |
(No difference)
| |
Latest revision as of 19:19, 12 August 2020
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.
