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.