From ff87da57d195fd80f4c5cb51925f3b4db75ef020 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Wed, 14 Jun 2017 17:00:09 -0300 Subject: tdf#84675 Add help page for FV function of VBA Change-Id: Ic1ac6629eed117d6d2ec8802162e69a45e599a0c Reviewed-on: https://gerrit.libreoffice.org/38802 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot (cherry picked from commit 969c5806ff0d958e8dc19d1abe98a1493842e4ca) Reviewed-on: https://gerrit.libreoffice.org/38804 --- AllLangHelp_sbasic.mk | 1 + source/text/sbasic/shared/03140001.xhp | 76 ++++++++++++++++++++++++++ source/text/sbasic/shared/special_vba_func.xhp | 2 +- 3 files changed, 78 insertions(+), 1 deletion(-) create mode 100644 source/text/sbasic/shared/03140001.xhp diff --git a/AllLangHelp_sbasic.mk b/AllLangHelp_sbasic.mk index 8459df924b..4d8075d258 100644 --- a/AllLangHelp_sbasic.mk +++ b/AllLangHelp_sbasic.mk @@ -325,6 +325,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sbasic,\ helpcontent2/source/text/sbasic/shared/03132400 \ helpcontent2/source/text/sbasic/shared/03132500 \ helpcontent2/source/text/sbasic/shared/03140000 \ + helpcontent2/source/text/sbasic/shared/03140001 \ 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/03140001.xhp b/source/text/sbasic/shared/03140001.xhp new file mode 100644 index 0000000000..8246842a67 --- /dev/null +++ b/source/text/sbasic/shared/03140001.xhp @@ -0,0 +1,76 @@ + + + + + + + FV Function [Runtime - VBA] + /text/sbasic/shared/03140001.xhp + + + + + + +
+ + FV function + + + +FV Function [Runtime - VBA] +Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value). +
+ + + + +FV(Rate as Double, NPer as Double, Pmt as Double, [PV as Variant], [Due as Variant]) + + + +Double + + +Rate is the periodic interest rate. +NPer is the total number of periods (payment period). +Pmt is the annuity paid regularly per period. +PV (optional) is the (present) cash value of an investment. +Due (optional) defines whether the payment is due at the beginning or the end of a period. +0 - the payment is due at the end of the period; +1 - the payment is due at the beginning of the period. + + + + + +Sub ExampleFV + Dim myFV As Double + myFV = =FV(0.04, 2, 750, 2500) + Print myFV ' returns 4234.00 currency units. The value at the end of the investment is 4234.00 currency units. +End Sub + + +
+FV function in CALC +VBA financial functions +
+ + + diff --git a/source/text/sbasic/shared/special_vba_func.xhp b/source/text/sbasic/shared/special_vba_func.xhp index 34296bdd92..f42d5b8b2c 100644 --- a/source/text/sbasic/shared/special_vba_func.xhp +++ b/source/text/sbasic/shared/special_vba_func.xhp @@ -70,7 +70,7 @@ DDB - FV + FV IPmt -- cgit