Microsoft KB Archive/103894

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

= 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.