diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2019-11-08 16:07:20 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2019-11-10 01:25:53 +0100 |
| commit | b5047e08bba1ffff68d3c05213a27138ec41bdea (patch) | |
| tree | a3e447498a0aa214f810a5e639b26e11b821b439 /source/text | |
| parent | 2991e4aee30ffb095601812744fe16720290cc62 (diff) | |
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.hallot@libreoffice.org>
Diffstat (limited to 'source/text')
| -rw-r--r-- | source/text/scalc/01/func_averageif.xhp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/source/text/scalc/01/func_averageif.xhp b/source/text/scalc/01/func_averageif.xhp index b9e78bcfda..00b9db3a16 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"/> |