Microsoft KB Archive/103894: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (X010 moved page Microsoft KB Archive/Q103894 to Microsoft KB Archive/103894 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/") |
(No difference)
|
Latest revision as of 19:13, 12 August 2020
Works: Using the ROUND() Function to a Set Limit PSS ID Number: Q103894 Article last modified on 10-18-1993 PSS database name: M_WorKs
2.00 3.00
MACINTOSH
The information in this article applies to: |
- Microsoft Works for the Macintosh, versions 2.0 and 3.0 |
SUMMARY
To round a number to a set limit, use the following formula
=ROUND(value/limit,0)*limit
where “value” is either a cell reference to the actual value to be rounded or a number to be rounded, and “limit” is the number to which you are rounding.
For example, to round the number in cell A1 to the nearest .05, use the following formula:
=ROUND(A1/.05,0)*.05
For more information about the ROUND() function, see page 380 of the “Microsoft Works User’s Guide.”
Additional reference words: 2.00 3.00 mac mwksss m_eXcel
Copyright Microsoft Corporation 1993.