summaryrefslogtreecommitdiff log msg author committer range
path: root/source/text/sbasic/shared
diff options
 context: 12345678910152025303540 space: includeignore mode: unifiedssdiffstat only
Diffstat (limited to 'source/text/sbasic/shared')
-rw-r--r--source/text/sbasic/shared/03140003.xhp77
-rw-r--r--source/text/sbasic/shared/special_vba_func.xhp2
2 files changed, 78 insertions, 1 deletions
 diff --git a/source/text/sbasic/shared/03140003.xhp b/source/text/sbasic/shared/03140003.xhpnew file mode 100644index 000000000..cd5fc6f75--- /dev/null+++ b/source/text/sbasic/shared/03140003.xhp@@ -0,0 +1,77 @@++++++ + IRR Function [Runtime - VBA]+ /text/sbasic/shared/03140003.xhp+ ++++++
++ IRR function++++IRR Function [Runtime - VBA]+Calculates the internal rate of return for an investment.+
+++++IRR(Values() as Double , [Guess as Variant])++++Double+++Values(): The array of values of the cash-flow. The values represent cash flow values at regular intervals, at least one value must be negative (payments), and at least one value must be positive (income).+Guess An initial estimate at what the IRR will be.++++++REM ***** BASIC *****+Option VBASupport 1+Sub ExampleIRR+ Dim cashFlow(0 to 3) As Double+ cashFlow(0) = -10000+ cashFlow(1) = 3500+ cashFlow(2) = 7600+ cashFlow(3) = 1000+ irrValue = IRR(cashFlow) * 100+ Print irrValue ' returns 11.3321028236252 . The internal rate of return of the cash flow.+End Sub+++
+IRR function in CALC+VBA financial functions+
+++
\ No newline at end of filediff --git a/source/text/sbasic/shared/special_vba_func.xhp b/source/text/sbasic/shared/special_vba_func.xhpindex 582e2ce0e..12d68f22e 100644--- a/source/text/sbasic/shared/special_vba_func.xhp+++ b/source/text/sbasic/shared/special_vba_func.xhp@@ -76,7 +76,7 @@ IPmt - IRR+ IRR MIRR