Microsoft KB Archive/60355

Works: Interest, Principal Fields Off in AMORTIZE.WKS

PSS ID Number: Q60355 Article last modified on 10-16-1998

2.00 3.00

MS-DOS

=
========================================================= 2.00 3.00 MS-DOS kbother

= SUMMARY =

When running the AMORTIZE.WKS template file supplied with Works Version 2.00, the Interest and Principal fields are sometimes off by one cent because numbers are not rounded off and the number remains as calculated. For example, the number “1.239568” appears as “1.23” instead of rounding up to “1.24”.

The following formula is a workaround to round off the numbers:

  Modify the Payment field formula located at E9 to read as follows: =INT(PMT(princpl,rate/period,pmts)*100+0.5)/100   Modify the Interest field formula located at D16 to read as follows: =INT($rate/$ periodC16100+0.5)/100 

This workaround allows the Interest and Principal fields to always add up to the correct monthly payment.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words: ====================================================================== Version : 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.