[office-formula] 6.11.23 IPMT

[Eric Patterson <ericpa@exchange.microsoft.com>]

The third test case for the IPMT Function appears to have an incorrect result specified.

Expression:
=IPMT(5%/12;10;360;100000)+IPMT(5%/12;10;360;100000)-PMT(5%/12;360;100000)

Result:
0


As written, I believe that the function should return -287.35.  It appears that the intent of the test case was to show how IPMT and PMT are related.  There is nothing in the text of the function that describes this.  If this is critical to the function, it should be added to the text.

-Eric