Microsoft KB Archive/24719

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 18:19, 12 August 2020 by X010 (talk | contribs) (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/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.