diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-10-05 22:36:12 +0200 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-10-05 22:39:49 +0200 |
| commit | 2ca0ebe7c4f01d2e9a60aa1127ed4f1d84851b33 (patch) | |
| tree | 5d8b80ca8f3498fae1b9b388e1b4ae347fbb4a09 /source/text/scalc | |
| parent | fc8fdf63f2eda1bf4715a288f07fd5598970406f (diff) | |
Fix duplicate information on AVERAGEIF
Change-Id: I7779c46a665fd1a23012da78c340258675226a3c
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/103973
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc')
| -rw-r--r-- | source/text/scalc/01/func_averageif.xhp | 1 |
1 files changed, 0 insertions, 1 deletions
diff --git a/source/text/scalc/01/func_averageif.xhp b/source/text/scalc/01/func_averageif.xhp index 00b9db3a16..592afe6e75 100644 --- a/source/text/scalc/01/func_averageif.xhp +++ b/source/text/scalc/01/func_averageif.xhp @@ -38,7 +38,6 @@ <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"/> -<warning id="par_id38832436828097">In all calculations below, range for average calculation contains the row #6, but it is ignored, because it contains text.</warning> <h4 id="hd_id229513120314273">Simple usage</h4> <paragraph id="par_id2509201519225446" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(B2:B6;"<35")</item></paragraph> <paragraph id="par_id11322891219251" role="paragraph" xml-lang="en-US">Calculates the average for values of the range B2:B6 that are less than 35. Returns 19, because the second row does not participate in the calculation.</paragraph> |