source/text/scalc/01/func_averageif.xhp | 1 -
1 file changed, 1 deletion(-)
New commits:
commit 2ca0ebe7c4f01d2e9a60aa1127ed4f1d84851b33
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon Oct 5 22:36:12 2020 +0200
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon Oct 5 22:39:49 2020 +0200
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.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/func_averageif.xhp
b/source/text/scalc/01/func_averageif.xhp
index 00b9db3a1..592afe6e7 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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
