Works: Rounding Values Up or Down a Set Amount PSS ID Number: Q40973 Article last modified on 05-11-1993 PSS database name: M_WorKs
1.00 1.10 2.00 3.00
MACINTOSH
The information in this article applies to: |
- Microsoft Works for the Macintosh, versions 1.0, 1.1, 2.0, and 3.0 |
Summary:
In the Microsoft Works Spreadsheet module, to round values up to a set amount, use the following formula:
=INT(<value to round>/<rounding limit>+.9999) * <rounding limit>
To round values down to a set amount, use the following formula:
=INT(<value to round>/<rounding limit>) * <rounding limit>
Note: The value to round can either be a number or a cell reference.
More Information:
For example, to round the value in cell A1 up to the nearest 50, use the following formula:
=INT(A1/50 + .9999) * 50
To round $45.32 up to the nearest dollar, use the following formula:
=INT(45.32 + .9999)
Additional reference words: 1.00 1.10 2.00 3.00 mwksss mwksdb noupd
Copyright Microsoft Corporation 1993.