summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSteve Fanning <stevemfanning@yahoo.co.uk>2020-06-03 10:05:24 +0200
committerOlivier Hallot <olivier.hallot@libreoffice.org>2020-06-08 19:04:04 +0200
commit13eadf6de9cc483db44c399feb6a657fe8fde2a3 (patch)
treed23e50911beac23e886f8f0cf0af408e0b2d19dc
parent4a23b97189fc671c10d8ab42c1fc53946247cf8f (diff)
Improve help information for ACCRINT() function to better explain the behaviour of the Par argument.
Change-Id: Ia1fb54abe828dc9d0310e83f9552099759b96d40 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95329 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> (cherry picked from commit e04a83713f38be33d0c51cc35d0c457919a3f213) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95739 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
-rw-r--r--source/text/scalc/01/04060103.xhp3
1 files changed, 2 insertions, 1 deletions
diff --git a/source/text/scalc/01/04060103.xhp b/source/text/scalc/01/04060103.xhp
index 8a8efbffb8..549aba1eab 100644
--- a/source/text/scalc/01/04060103.xhp
+++ b/source/text/scalc/01/04060103.xhp
@@ -101,7 +101,8 @@
<paragraph xml-lang="en-US" id="par_id3154486" role="paragraph">
<emph>Rate</emph> (required) is the annual nominal rate of interest (coupon interest rate)</paragraph>
<paragraph xml-lang="en-US" id="par_id3156445" role="paragraph">
- <emph>Par</emph> (optional) is the par value of the security.</paragraph>
+ <emph>Par</emph> (optional) is the par value of the security. If omitted, a default value of 1000 is used.</paragraph>
+ <note id="par_id961591171682507">We recommend that you always specify the value that you require for ACCRINT’s <emph>Par</emph> argument, rather than allowing Calc to apply an arbitrary default. This will make your formula easier to understand and easier to maintain.</note>
<paragraph xml-lang="en-US" id="par_id3149406" role="paragraph">
<emph>Frequency</emph> (required) is the number of interest payments per year (1, 2 or 4).</paragraph>
<embed href="text/scalc/01/func_yearfrac.xhp#basis"/>