Microsoft KB Archive/142970

= Formula Error: Mortgage Loan Analysis Extra Payments =

Article ID: 142970

Article Last Modified on 11/15/2004

-

APPLIES TO


 * Microsoft Works 4.0 Standard Edition

-



This article was previously published under Q142970



SYMPTOMS
When you use the Extra Payments option in the Mortgage Loan Analysis TaskWizard, you may notice that the amount calculated in the Total Cost cell (that is, cell I17), is slightly off.



CAUSE
This problem occurs because the formula in this cell contains an incorrect cell reference.



RESOLUTION
Microsoft has confirmed this to be a problem in This problem was corrected in. Microsoft has confirmed that this is a problem in Works for Windows version 4.0.

This problem was corrected in Works version 4.0a.

To fix the problem in version 4.0, you must correct a formula error in the Mortgage Loan Analysis: Extra Payments spreadsheet, and then you need to save the file as a Works template.

The formula in cell I17 adds total Extra Payments into the Total Cost cell. In cell I17 the formula should read:

=IF(AND($E$14,$E$5,$E$6,$E$7),"",IF(AND($E$5,$E$6,$E$7),$E$18+$E$5,""))

You need to correct this formula, and then save the file as a Works template.

To save a file as a Works template

 * 1) On the File menu, click Save As.
 * 2) Click the Template button.
 * 3) Type a name for the template. For example, you can call it Mortgage Loan Analysis Template.
 * 4) Click OK.

To access the template, select it from the User Defined Templates category on the TaskWizard tab of the Works Task Launcher.

Additional query words: 4.00 w_works wrong calc

Keywords: kbprb KB142970

-

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

© Microsoft Corporation. All rights reserved.