source/text/scalc/01/04060103.xhp | 1 +
1 file changed, 1 insertion(+)
New commits:
commit 2d1dfbc702217bde0e208de8f969cdb1b4262f81
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
Date: Sat Dec 16 21:55:15 2017 -0200
tdf#40460 Improve help for Calc IRR function
Change-Id: Ie61635f75ec8d208656623c61b31d1bc82c75663
Reviewed-on: https://gerrit.libreoffice.org/46625
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
Tested-by: Olivier Hallot <olivier.hal...@libreoffice.org>
(cherry picked from commit 8b0a4944747cde7395b36e53893d85dc8b07ee05)
Reviewed-on: https://gerrit.libreoffice.org/46626
diff --git a/source/text/scalc/01/04060103.xhp
b/source/text/scalc/01/04060103.xhp
index 0e81e4d74..d9dc2d47a 100644
--- a/source/text/scalc/01/04060103.xhp
+++ b/source/text/scalc/01/04060103.xhp
@@ -696,6 +696,7 @@
<emph>Guess</emph> (optional) is the estimated value. An iterative
method is used to calculate the internal rate of return. If you can provide
only few values, you should provide an initial guess to enable the
iteration.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3151258" role="heading"
level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3150630" role="paragraph">Under
the assumption that cell contents are A1=<item type="input">-10000</item>,
A2=<item type="input">3500</item>, A3=<item type="input">7600</item> and
A4=<item type="input">1000</item>, the formula <item
type="input">=IRR(A1:A4)</item> gives a result of 11,33%.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id461513468030965"
role="warning">Because of the iterative method used, it is possible for IRR to
fail and return <link href="text/scalc/05/02140000.xhp" name="Error 523">Error
523</link>, with "Error: Calculation does not converge" in the status bar. In
that case, try another value for Guess.</paragraph>
</section>
<section id="ispmt">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3151012"><bookmark_value>calculating; interests for unchanged
amortization installments</bookmark_value>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
