Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/24719

From BetaArchive Wiki

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.