Formula Error: Mortgage Loan Analysis Extra Payments (142970)


The information in this article applies to:

  • Microsoft Works for Windows 95, version 4.0
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.
Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kbprb KB142970
©2004 Microsoft Corporation. All rights reserved.