[Libreoffice-commits] help.git: source/text

Olivier Hallot (via logerrit) logerrit at kemper.freedesktop.org
Mon Oct 5 20:40:09 UTC 2020


 source/text/scalc/01/func_averageif.xhp |    1 -
 1 file changed, 1 deletion(-)

New commits:
commit 2ca0ebe7c4f01d2e9a60aa1127ed4f1d84851b33
Author:     Olivier Hallot <olivier.hallot at libreoffice.org>
AuthorDate: Mon Oct 5 22:36:12 2020 +0200
Commit:     Olivier Hallot <olivier.hallot at 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.hallot at 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>


More information about the Libreoffice-commits mailing list