Microsoft KB Archive/99594

= Works: Rounding Currency to the Nearest Value =

Article ID: 99594

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a
 * Microsoft Money 2000 Business & Personal Edition

-



This article was previously published under Q99594



SUMMARY
This article lists the formulas needed to round values to the nearest nickel, dime, or quarter.



MORE INFORMATION
To compute and round to the nearest nickel, the formula would be typed as follows:

=ROUND((A1/0.05),0)*0.05

To compute and round to the nearest dime, the formula would be typed as follows:

=ROUND((A1/0.1),0)*0.1

To compute and round to the nearest quarter, the formula would be typed as follows:

=ROUND((A1/0.25),0)*0.25

This single formula makes finding errors far more difficult and is not generally recommended.

Additional query words: w_works 2.00 2.00a 3.00 4.00 4.00a 4.50 4.50a rounding round ss nearest money change closest

Keywords: kbinfo KB99594

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.