summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorSteve Fanning <stevemfanning@yahoo.co.uk>2020-06-01 11:47:38 +0200
committerOlivier Hallot <olivier.hallot@libreoffice.org>2020-06-08 19:02:55 +0200
commita7337c9922374b225595776e7b5ab9f87c9e2856 (patch)
tree145c01c0f6e62775678d4094ce1af0e68a06527f
parent(04060184.xhp) Include square brackets in syntax sections to indicate optiona... (diff)
downloadhelp-a7337c9922374b225595776e7b5ab9f87c9e2856.zip
help-a7337c9922374b225595776e7b5ab9f87c9e2856.tar.gz
(04060185.xhp) Include square brackets in syntax sections to indicate optional parameters.
Change-Id: I8d099d9babe118c7592b060027dd037e9fbdadaf Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95245 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> (cherry picked from commit 79dfc48af63b0834aee096c65f92f1bc96fc1b6c) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95736 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
-rw-r--r--source/text/scalc/01/04060185.xhp8
1 files changed, 4 insertions, 4 deletions
diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp
index 1243793..65bfaec 100644
--- a/source/text/scalc/01/04060185.xhp
+++ b/source/text/scalc/01/04060185.xhp
@@ -38,7 +38,7 @@
<h2 id="hd_id3155071">RANK</h2>
<paragraph xml-lang="en-US" id="par_id3153976" role="paragraph"><ahelp hid="HID_FUNC_RANG">Returns the rank of a number in a sample.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3153250" role="code">RANK(Value; Data; Type)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3153250" role="code">RANK(Value; Data [; Type])</paragraph>
<paragraph xml-lang="en-US" id="par_id3154543" role="paragraph">
<emph>Value</emph> is the value, whose rank is to be determined.</paragraph>
<paragraph xml-lang="en-US" id="par_id3149130" role="paragraph">
@@ -62,7 +62,7 @@
<note id="par_id2653976">The difference between <item type="input">RANK.AVG</item> and <item type="input">RANK.EQ</item> occurs when there are duplicates in the list of values. The <item type="input">RANK.EQ</item> function returns the lower rank, whereas the <item type="input">RANK.AVG</item> function returns the average rank.</note>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph xml-lang="en-US" id="par_id2953250" role="code">RANK.AVG(Value; Data; Type)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2953250" role="code">RANK.AVG(Value; Data [; Type])</paragraph>
<paragraph xml-lang="en-US" id="par_id2954543" role="paragraph"><emph>Value</emph> is the value, whose rank is to be determined.</paragraph>
<paragraph xml-lang="en-US" id="par_id2949130" role="paragraph"><emph>Data</emph> is the array or range of data in the sample.</paragraph>
<paragraph xml-lang="en-US" id="par_id2950215" role="paragraph"><emph>Type</emph> (optional) is the sequence order.</paragraph>
@@ -82,7 +82,7 @@
<note id="par_id2753976">The difference between <item type="input">RANK.AVG</item> and <item type="input">RANK.EQ</item> occurs when there are duplicates in the list of values. The <item type="input">RANK.EQ</item> function returns the lower rank, whereas the <item type="input">RANK.AVG</item> function returns the average rank.</note>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph xml-lang="en-US" id="par_id2853250" role="code">RANK.EQ(Value; Data; Type)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2853250" role="code">RANK.EQ(Value; Data [; Type])</paragraph>
<paragraph xml-lang="en-US" id="par_id2854543" role="paragraph"><emph>Value</emph> is the value, whose rank is to be determined.</paragraph>
<paragraph xml-lang="en-US" id="par_id2849130" role="paragraph"><emph>Data</emph> is the array or range of data in the sample.</paragraph>
<paragraph xml-lang="en-US" id="par_id2850215" role="paragraph"><emph>Type</emph> (optional) is the sequence order.</paragraph>
@@ -665,7 +665,7 @@
<h2 id="hd_id3152952">PROB</h2>
<paragraph xml-lang="en-US" id="par_id3154110" role="paragraph"><ahelp hid="HID_FUNC_WAHRSCHBEREICH">Returns the probability that values in a range are between two limits.</ahelp> If there is no <item type="literal">End</item> value, this function calculates the probability based on the principle that the Data values are equal to the value of <item type="literal">Start</item>.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3147330" role="code">PROB(Data; Probability; Start; End)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3147330" role="code">PROB(Data; Probability; Start [; End])</paragraph>
<paragraph xml-lang="en-US" id="par_id3154573" role="paragraph">
<emph>Data</emph> is the array or range of data in the sample.</paragraph>
<paragraph xml-lang="en-US" id="par_id3156334" role="paragraph">