From 382289ba413f625b8cb41bb6702ad4c7b0e74ab0 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Wed, 14 Jun 2017 19:42:00 -0300 Subject: tdf#84675 Add help page for IPmt function of VBA Change-Id: Iddb382d9735c25f2ca77f8141457fb6bb497a696 Reviewed-on: https://gerrit.libreoffice.org/38809 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot --- AllLangHelp_sbasic.mk | 1 + source/text/sbasic/shared/03140002.xhp | 77 ++++++++++++++++++++++++++ source/text/sbasic/shared/special_vba_func.xhp | 2 +- 3 files changed, 79 insertions(+), 1 deletion(-) create mode 100644 source/text/sbasic/shared/03140002.xhp diff --git a/AllLangHelp_sbasic.mk b/AllLangHelp_sbasic.mk index 4d8075d258..d2435e0026 100644 --- a/AllLangHelp_sbasic.mk +++ b/AllLangHelp_sbasic.mk @@ -326,6 +326,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sbasic,\ helpcontent2/source/text/sbasic/shared/03132500 \ helpcontent2/source/text/sbasic/shared/03140000 \ helpcontent2/source/text/sbasic/shared/03140001 \ + helpcontent2/source/text/sbasic/shared/03140002 \ helpcontent2/source/text/sbasic/shared/05060700 \ helpcontent2/source/text/sbasic/shared/code-stubs \ helpcontent2/source/text/sbasic/shared/keys \ diff --git a/source/text/sbasic/shared/03140002.xhp b/source/text/sbasic/shared/03140002.xhp new file mode 100644 index 0000000000..a4ebc9cb38 --- /dev/null +++ b/source/text/sbasic/shared/03140002.xhp @@ -0,0 +1,77 @@ + + + + + + + IPmt Function [Runtime - VBA] + /text/sbasic/shared/03140002.xhp + + + + + + +
+ + IPmt function + + + +IPmt Function [Runtime - VBA] +Calculates the periodic amortizement for an investment with regular payments and a constant interest rate. +
+ + + + +IPmt(Rate as Double, Per as Double, NPer as Double, PV as Double, [FV as Variant], [Due as Variant]) + + + +Double + + +Rate is the periodic interest rate. +Per is the period, for which the compound interest is calculated. Period=NPER if compound interest for the last period is calculated. +NPer is the total number of periods, during which annuity is paid. +PV is the present cash value in sequence of payments. +FV (optional) is the desired value (future value) at the end of the periods. +Due (optional) is the due date for the periodic payments. +0 - the payment is due at the end of the period; +1 - the payment is due at the beginning of the period. + + + + + +Sub ExampleIPmt + Dim myIPmt As Double + myIPmt = IPmt(0.05,5,7,15000) + Print myIPmt ' returns -352.97 currency units. The compound interest during the fifth period (year) is 352.97 currency units. +End Sub + + +
+IPMT function in CALC +VBA financial functions +
+ + + \ No newline at end of file diff --git a/source/text/sbasic/shared/special_vba_func.xhp b/source/text/sbasic/shared/special_vba_func.xhp index f42d5b8b2c..582e2ce0e1 100644 --- a/source/text/sbasic/shared/special_vba_func.xhp +++ b/source/text/sbasic/shared/special_vba_func.xhp @@ -73,7 +73,7 @@ FV - IPmt + IPmt IRR -- cgit