Microsoft KB Archive/151466

= Works: Mortgage Analysis TaskWizard Errors Caused by Rounding =

Article ID: 151466

Article Last Modified on 11/15/2004

-

APPLIES TO


 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a

-



This article was previously published under Q151466



SYMPTOMS
When you create a spreadsheet document or use TaskWizards or templates, such as the Mortgage and Loan Analysis, from any of the versions of Works listed at the beginning of this article, you may discover some of the amounts calculated appear to be off by one cent.



CAUSE
Internal rounding will cause this when the computer calculates totals within the document. If the third significant digit in a number is .005 or higher, a cell formatted to display two decimal places rounds up one digit or cent. Since the calculations are done on the actual number, the internal calculations are correct even though the displayed amount may be off by one cent.



Steps to Reproduce Behavior
 Open the Taskwizard (or template) for the Mortgage and Loan Analysis spreadsheet. Click on the Standard Loan.

NOTE: In Works 4.0, 4.0a, 4.5, and 4.5a the Taskwizard is located under the Business Management and/or Household Management section.

In Works 3.0x it is located under AutoStart Personal group, Personal Finances category. Enter the following into the sheet:

NOTE: In Works 3.0x, Amount Financed is titled "Principal' and the cell references are G4, G5, and so on. In Works 4.0, 4.0a, 4.5, and 4.5a, highlight columns A-H in rows 21 -29.

In Works 3.0x, highlight columns A-G in rows 19 - 29. On the Edit menu, click Fill Down.

NOTE: In Works 4.0, 4.0a, 4.5, and 4.5a, Cell H29 shows the accumulated principal correctly (1000.00) Add the accumulated interest in G21 (24.18) with the interest from the next payment in D22 (4.65).

The value in G22 should be 28.83, however it displays as 28.82, off by .01

If you format cells D18-D29 and G18-G29 to display 7 decimal places, and add cells G21 and D22, the value in G22 is correct(28.82).

NOTE: In works 4.0, 4.0a, 4.5, and 4.5a the same issue applies to cells H19-H29 (Accumulated Principal) and E18-E29 (Principal).

Additional query words: 3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a w_works wizard rounded wrong incorrect value calc

Keywords: kbprb KB151466

-

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

© Microsoft Corporation. All rights reserved.