source/text/scalc/01/func_averageif.xhp | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
New commits:
commit b5047e08bba1ffff68d3c05213a27138ec41bdea
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Fri Nov 8 16:07:20 2019 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sun Nov 10 01:25:53 2019 +0100
Follow-up patch of 82094
Removed reference of Criterion
Change-Id: I8dd11b0a6d44bad183447a344a2e37067fa66c44
Reviewed-on: https://gerrit.libreoffice.org/82322
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/func_averageif.xhp
b/source/text/scalc/01/func_averageif.xhp
index b9e78bcfd..00b9db3a1 100644
--- a/source/text/scalc/01/func_averageif.xhp
+++ b/source/text/scalc/01/func_averageif.xhp
@@ -33,8 +33,8 @@
<paragraph id="par_id24499731228013" role="paragraph"
xml-lang="en-US"><emph>Criterion</emph> – required argument. A condition in the
form of expression or a cell reference with expression that defines what cells
should be used to calculate the mean. The expression can contain text, numbers,
regular expressions (if enabled in calculation options) or wildcards (if
enabled in calculation options).</paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
<paragraph id="par_id174711913219765" role="paragraph"
xml-lang="en-US"><emph>Average_Range</emph> – optional. It is a range of values
for calculating the mean.</paragraph>
-<note id="par_id45123108916423">Note that if the <emph>Average_Range</emph> is
not specified, <emph>Range</emph> is used for both, the calculation of the mean
and the search according to the condition. If the <emph>Average_Range</emph> is
specified, the <emph>Range</emph> is used only for the condition test, while
<emph>Average_Range</emph> is used for the mean calculation.<br/>
-The <emph>Criterion</emph> needs to be a string expression, in particular, the
<emph>Criterion</emph> needs to be enclosed in quotation marks ("Criterion")
with the exception of the names of functions, cell references and an operation
of a string concatenation (&).</note><embed
href="text/scalc/01/ODFF.xhp#odff"/>
+<note id="par_id45123108916423">If the <emph>Average_Range</emph> is not
specified, <emph>Range</emph> is used for both, the calculation of the mean and
the search according to the condition. If <emph>Average_Range</emph> is
specified, the <emph>Range</emph> is used only for the condition test, while
<emph>Average_Range</emph> is used for the average calculation.</note>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<warning id="par_id278275053653">If a cell in a range of values for
calculating the mean is empty or contains text, function AVERAGEIF ignores this
cell.<br/>
If the whole range is empty, contains only text or all values of the range do
not satisfy the condition (or any combination of those), the function returns
the #DIV/0! error. </warning>
<embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
