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.