summaryrefslogtreecommitdiff log msg author committer range
diff options
 context: 12345678910152025303540 space: includeignore mode: unifiedssdiffstat only
author committer Olivier Hallot 2017-12-16 21:55:15 -0200 Olivier Hallot 2017-12-17 00:58:05 +0100 8b0a4944747cde7395b36e53893d85dc8b07ee05 (patch) 6878795eae00b0b224cb76cf07a5f436b1084bae 52613d9b557df908883211cbfb49e7a5f2b9ce3c (diff)
tdf#40460 Improve help for Calc IRR function
Change-Id: Ie61635f75ec8d208656623c61b31d1bc82c75663 Reviewed-on: https://gerrit.libreoffice.org/46625 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
-rw-r--r--source/text/scalc/01/04060103.xhp1
1 files changed, 1 insertions, 0 deletions
 diff --git a/source/text/scalc/01/04060103.xhp b/source/text/scalc/01/04060103.xhpindex 0e81e4d744..d9dc2d47a5 100644--- a/source/text/scalc/01/04060103.xhp+++ b/source/text/scalc/01/04060103.xhp@@ -696,6 +696,7 @@ Guess (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. Example Under the assumption that cell contents are A1=-10000, A2=3500, A3=7600 and A4=1000, the formula =IRR(A1:A4) gives a result of 11,33%.+ Because of the iterative method used, it is possible for IRR to fail and return Error 523, with "Error: Calculation does not converge" in the status bar. In that case, try another value for Guess.
calculating; interests for unchanged amortization installments