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-03 14:07:49 +0200
commite04a83713f38be33d0c51cc35d0c457919a3f213 (patch)
tree7f502efeda3bc0e8a7bad371c8a7967281357bff
parente10bfae45bc138b0c2351a7cb6bd3cc591bea388 (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>
-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"/>