Microsoft KB Archive/42331

Multiplan: IPMT Function Returns Wrong Value PSS ID Number: Q42331 Article last modified on 04-08-1991 PSS database name: D_MPlan

4.01

MS-DOS

Summary:

The IPMT (interest payment for an investment) function can return an incorrect value if the final argument in the function is set to 1. For example, the function IPMT(.1,6,60,10000,0,1) returns the value -998.41. This value is incorrect. The correct value is -907.26.

Microsoft has confirmed this to be a problem in Multiplan version 4.01. This problem was corrected in Multiplan version 4.20. Updated or new Microsoft software can be ordered in the US by contacting Microsoft End User Sales and Service at (800) 426-9400. If calling from outside the US, contact Microsoft International Customer Service at (206) 936-8661.

Copyright Microsoft Corporation 1991.