summaryrefslogtreecommitdiffstats
path: root/source/text/scalc/01/04060184.xhp
diff options
context:
space:
mode:
authorSophia Schröder <sophia.schroeder@libreoffice.org>2018-04-23 12:58:00 +0100
committerOlivier Hallot <olivier.hallot@libreoffice.org>2018-04-23 23:10:09 +0200
commit3db795172c8031ac1a88967f28858812a2d35089 (patch)
tree2804f2c8d15cd9ddad44604079a1ac813c14de59 /source/text/scalc/01/04060184.xhp
parentHelponline: Tweak pagination symbols for improved clarity (diff)
downloadhelp-3db795172c8031ac1a88967f28858812a2d35089.tar.gz
help-3db795172c8031ac1a88967f28858812a2d35089.zip
Improve formatting in help text.
Change-Id: I873128ed6353caf37f063a87361bd0a6f7c79f96 Reviewed-on: https://gerrit.libreoffice.org/53321 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01/04060184.xhp')
-rw-r--r--source/text/scalc/01/04060184.xhp44
1 files changed, 22 insertions, 22 deletions
diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp
index 68c7f81d21..fd6dc0eceb 100644
--- a/source/text/scalc/01/04060184.xhp
+++ b/source/text/scalc/01/04060184.xhp
@@ -38,8 +38,8 @@
<paragraph xml-lang="en-US" id="par_id3153709" role="paragraph"><ahelp hid="HID_FUNC_MAX">Returns the maximum value in a list of arguments.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id9282509" role="paragraph">Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3154256" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3147340" role="code">MAX(Number1; Number2; ...Number30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149568" role="paragraph"><emph>Number1; Number2;...Number30</emph> are numerical values or ranges. </paragraph>
+<paragraph xml-lang="en-US" id="par_id3147340" role="code">MAX(Number1; Number2; ...; Number30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149568" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges. </paragraph>
<paragraph xml-lang="en-US" id="hd_id3153963" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3147343" role="paragraph">
<item type="input">=MAX(A1;A2;A3;50;100;200)</item> returns the largest value from the list.</paragraph>
@@ -54,8 +54,8 @@
<paragraph xml-lang="en-US" id="par_id3150363" role="paragraph"><ahelp hid="HID_FUNC_MAXA">Returns the maximum value in a list of arguments. In opposite to MAX, here you can enter text. The value of the text is 0.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id7689443" role="paragraph">The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3150516" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3166431" role="code">MAXA(Value1; Value2; ... Value30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150202" role="paragraph"><emph>Value1; Value2;...Value30</emph> are values or ranges. Text has the value of 0.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3166431" role="code">MAXA(Value1; Value2; ...; Value30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150202" role="paragraph"><emph>Value1; Value2;...; Value30</emph> are values or ranges. Text has the value of 0.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3156290" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3156446" role="paragraph">
<item type="input">=MAXA(A1;A2;A3;50;100;200;"Text")</item> returns the largest value from the list.</paragraph>
@@ -69,8 +69,8 @@
<paragraph xml-lang="en-US" id="hd_id3153820" role="heading" level="2">MEDIAN</paragraph>
<paragraph xml-lang="en-US" id="par_id3151241" role="paragraph"><ahelp hid="HID_FUNC_MEDIAN">Returns the median of a set of numbers. In a set containing an uneven number of values, the median will be the number in the middle of the set and in a set containing an even number of values, it will be the mean of the two values in the middle of the set.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3148871" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3155264" role="code">MEDIAN(Number1; Number2; ...Number30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150109" role="paragraph"><emph>Number1; Number2;...Number30</emph> are values or ranges, which represent a sample. Each number can also be replaced by a reference.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155264" role="code">MEDIAN(Number1; Number2; ...; Number30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150109" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are values or ranges, which represent a sample. Each number can also be replaced by a reference.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3144506" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3145078" role="paragraph">for an odd number: <item type="input">=MEDIAN(1;5;9;20;21)</item> returns 9 as the median value.</paragraph>
<paragraph xml-lang="en-US" id="par_id3149126" role="paragraph">for an even number: <item type="input">=MEDIAN(1;5;9;20)</item> returns the average of the two middle values 5 and 9, thus 7.</paragraph>
@@ -83,8 +83,8 @@
<paragraph xml-lang="en-US" id="par_id3143222" role="paragraph"><ahelp hid="HID_FUNC_MIN">Returns the minimum value in a list of arguments.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id2301400" role="paragraph">Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3154651" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3146964" role="code">MIN(Number1; Number2; ...Number30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153486" role="paragraph"><emph>Number1; Number2;...Number30</emph> are numerical values or ranges.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3146964" role="code">MIN(Number1; Number2; ...; Number30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153486" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3155523" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3154734" role="paragraph">
<item type="input">=MIN(A1:B100)</item> returns the smallest value in the list.</paragraph>
@@ -97,8 +97,8 @@
<paragraph xml-lang="en-US" id="par_id3147249" role="paragraph"><ahelp hid="HID_FUNC_MINA">Returns the minimum value in a list of arguments. Here you can also enter text. The value of the text is 0.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id4294564" role="paragraph">The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3150435" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153336" role="code">MINA(Value1; Value2; ... Value30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3146098" role="paragraph"><emph>Value1; Value2;...Value30</emph> are values or ranges. Text has the value of 0.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153336" role="code">MINA(Value1; Value2; ...; Value30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3146098" role="paragraph"><emph>Value1, Value2, ..., Value30</emph> are values or ranges. Text has the value of 0.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3148743" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3147401" role="paragraph">
<item type="input">=MINA(1;"Text";20)</item> returns 0.</paragraph>
@@ -113,8 +113,8 @@
<paragraph role="heading" id="hd_id3166465" xml-lang="en-US" level="2">AVEDEV</paragraph>
<paragraph role="paragraph" id="par_id3150373" xml-lang="en-US"><ahelp hid="HID_FUNC_MITTELABW">Returns the average of the absolute deviations of data points from their mean.</ahelp> Displays the diffusion in a data set.</paragraph>
<paragraph role="heading" id="hd_id3150038" xml-lang="en-US" level="3">Syntax</paragraph>
-<paragraph role="code" id="par_id3145636" xml-lang="en-US">AVEDEV(Number1; Number2; ...Number30)</paragraph>
-<paragraph role="paragraph" id="par_id3157871" xml-lang="en-US"><emph>Number1, Number2,...Number30</emph> are values or ranges that represent a sample. Each number can also be replaced by a reference.</paragraph>
+<paragraph role="code" id="par_id3145636" xml-lang="en-US">AVEDEV(Number1; Number2; ...; Number30)</paragraph>
+<paragraph role="paragraph" id="par_id3157871" xml-lang="en-US"><emph>Number1, Number2, ..., Number30</emph> are values or ranges that represent a sample. Each number can also be replaced by a reference.</paragraph>
<paragraph role="heading" id="hd_id3149725" xml-lang="en-US" level="3">Example</paragraph>
<paragraph role="paragraph" id="par_id3153122" xml-lang="en-US">
<item type="input">=AVEDEV(A1:A50)</item>
@@ -127,8 +127,8 @@
<paragraph xml-lang="en-US" id="hd_id3145824" role="heading" level="2">AVERAGE</paragraph>
<paragraph xml-lang="en-US" id="par_id3150482" role="paragraph"><ahelp hid="HID_FUNC_MITTELWERT">Returns the average of the arguments.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3146943" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154679" role="code">AVERAGE(Number1; Number2; ...Number30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150741" role="paragraph"><emph>Number1; Number2;...Number30</emph> are numerical values or ranges.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154679" role="code">AVERAGE(Number1; Number2; ...; Number30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150741" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3153039" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3151232" role="paragraph">
<item type="input">=AVERAGE(A1:A50)</item>
@@ -141,8 +141,8 @@
<paragraph xml-lang="en-US" id="hd_id3148754" role="heading" level="2">AVERAGEA</paragraph>
<paragraph xml-lang="en-US" id="par_id3145138" role="paragraph"><ahelp hid="HID_FUNC_MITTELWERTA">Returns the average of the arguments. The value of a text is 0.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3153326" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149734" role="code">AVERAGEA(Value1; Value2; ... Value30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3155260" role="paragraph"><emph>Value1; Value2;...Value30</emph> are values or ranges. Text has the value of 0.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149734" role="code">AVERAGEA(Value1; Value2; ...; Value30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155260" role="paragraph"><emph>Value1, Value2, ..., Value30</emph> are values or ranges. Text has the value of 0.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3149504" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3150864" role="paragraph">
<item type="input">=AVERAGEA(A1:A50)</item>
@@ -165,8 +165,8 @@
<paragraph xml-lang="en-US" id="par_id3153085" role="paragraph"><ahelp hid="HID_FUNC_MODALWERT">Returns the most common value in a data set.</ahelp> If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesn't appear twice.</paragraph>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
<paragraph xml-lang="en-US" id="hd_id3153003" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3155950" role="code">MODE(Number1; Number2; ...Number30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150337" role="paragraph"><emph>Number1; Number2;...Number30</emph> are numerical values or ranges.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155950" role="code">MODE(Number1; Number2; ...; Number30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150337" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3153571" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3153733" role="paragraph">
<item type="input">=MODE(A1:A50)</item>
@@ -181,8 +181,8 @@
<paragraph xml-lang="en-US" id="hd_id2953933" role="heading" level="2">MODE.SNGL</paragraph>
<paragraph xml-lang="en-US" id="par_id2953085" role="paragraph"><ahelp hid="HID_FUNC_MODAL_VALUE_MS">Returns the most frequently occurring, or repetitive, value in an array or range of data.</ahelp> If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesn't appear twice.</paragraph>
<paragraph xml-lang="en-US" id="hd_id2953003" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id2955950" role="code">MODE.SNGL(Number1; Number2; ...Number30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id2950337" role="paragraph"><emph>Number1; Number2;...Number30</emph> are numerical values or ranges.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2955950" role="code">MODE.SNGL(Number1; Number2; ...; Number30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2950337" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges.</paragraph>
<paragraph xml-lang="en-US" id="par_id2963792" role="warning">If the data set contains no duplicate data points, MODE.SNGL returns the #VALUE! error value.</paragraph>
<paragraph xml-lang="en-US" id="hd_id2953571" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id2953733" role="paragraph"><item type="input">=MODE.SNGL(A1:A50)</item></paragraph>
@@ -195,8 +195,8 @@
<paragraph xml-lang="en-US" id="hd_id2853933" role="heading" level="2">MODE.MULT</paragraph>
<paragraph xml-lang="en-US" id="par_id2853085" role="paragraph"><ahelp hid="HID_FUNC_MODAL_VALUE_MULTI">Returns a vertical array of the statistical modes (the most frequently occurring values) within a list of supplied numbers.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id2853003" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id2855950" role="code">MODE.MULT(Number1; Number2; ...Number30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id2850337" role="paragraph"><emph>Number1; Number2;...Number30</emph> are numerical values or ranges.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2855950" role="code">MODE.MULT(Number1; Number2; ...; Number30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2850337" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges.</paragraph>
<paragraph xml-lang="en-US" id="par_id2863792" role="warning">As the MODE.MULT function returns an array of values, it must be entered as an array formula. If the function is not entered as an array formula, only the first mode is returned, which is the same as using the MODE.SNGL function.</paragraph>
<paragraph xml-lang="en-US" id="hd_id2853571" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id2853733" role="paragraph"><item type="input">=MODE.MULT(A1:A50)</item></paragraph>