Microsoft KB Archive/40973

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

Summary:

In the Microsoft Works Spreadsheet module, to round values up to a set amount, use the following formula:

=INT( / +.9999) *

To round values down to a set amount, use the following formula:

=INT( / ) *

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.