Difference between revisions of "Microsoft KB Archive/24719"

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.