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.
