Difference between revisions of "Documentation/How Tos/Calc: IPMT function"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (Talk | contribs) |
|||
Line 102: | Line 102: | ||
* Excel claims that this function calculates the "interest payment for a given period". This seems to be wrong - it is the interest in the <u>payment</u> for that period. Calc and Excel produce the same results. Gnumeric returns slightly different results when payment is at the start of each period; possibly it calculates what Excel says it calculates. | * Excel claims that this function calculates the "interest payment for a given period". This seems to be wrong - it is the interest in the <u>payment</u> for that period. Calc and Excel produce the same results. Gnumeric returns slightly different results when payment is at the start of each period; possibly it calculates what Excel says it calculates. | ||
− | {{ | + | {{SeeAlso|EN| |
* [[Documentation/How_Tos/Calc: CUMIPMT function|CUMIPMT]] | * [[Documentation/How_Tos/Calc: CUMIPMT function|CUMIPMT]] | ||
* [[Documentation/How_Tos/Calc: CUMIPMT_ADD function|CUMIPMT_ADD]] | * [[Documentation/How_Tos/Calc: CUMIPMT_ADD function|CUMIPMT_ADD]] |
Revision as of 09:35, 17 July 2018
CALC FUNCTIONS
- Financial FunctionsDepreciation
- AmordegrcAmorlincDbDdbSlnSydVdbPayment Streams, Annuities, Loans
- CumipmtCumipmt AddCumprincCumpinc AddFvFvscheduleIpmtIrrIspmtMirrNperNpvPmtPpmtPvRateRriXirrXnpvSecurities
-