diff options
| author | Steve Fanning <stevemfanning@yahoo.co.uk> | 2020-06-01 11:47:38 +0200 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-06-08 19:02:55 +0200 |
| commit | a7337c9922374b225595776e7b5ab9f87c9e2856 (patch) | |
| tree | 145c01c0f6e62775678d4094ce1af0e68a06527f | |
| parent | 4a8b7a806112d636b174666636bd8d74ddcdbfba (diff) | |
(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.xhp | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp index 1243793dd3..65bfaec408 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"> |