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

Tue, 29 Dec 2015 15:29:35 -0800 

 source/text/scalc/01/func_averageif.xhp |    6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

New commits:
commit 7338cf7526423d3e20cf408416e17d5f82c60e34
Author: Stanislav Horacek <stanislav.hora...@gmail.com>
Date:   Tue Dec 29 22:09:21 2015 +0100

    AVERAGEIF: use "character" instead of "symbol"
    
    Change-Id: I586658c5da91c3fc5a3d35c5cdfa2d6b4a42dc1f
    Reviewed-on: https://gerrit.libreoffice.org/21007
    Reviewed-by: Adolfo Jayme Barrientos <fit...@ubuntu.com>
    Tested-by: Adolfo Jayme Barrientos <fit...@ubuntu.com>

diff --git a/source/text/scalc/01/func_averageif.xhp 
b/source/text/scalc/01/func_averageif.xhp
index 277abb6..c41e8e9 100644
--- a/source/text/scalc/01/func_averageif.xhp
+++ b/source/text/scalc/01/func_averageif.xhp
@@ -55,13 +55,13 @@ If the whole range is empty, contains only text or all 
values of the range do no
 <paragraph id="par_id2509201519360514" role="paragraph" xml-lang="en-US"><item 
type="input">=AVERAGEIF(A2:A6;"pen";B2:B6)</item></paragraph>
 <paragraph id="par_id14714860719948" role="paragraph" xml-lang="en-US">The 
function searches what cells from the range A2:A6 contain only the word 
“pen”, and calculates the average of corresponding values from the B2:B6 
range. Returns 35, because only the second row participates in the calculation. 
The search is performed in the A2:A6 range, but the values are returned from 
the B2:B6 range.</paragraph>
 <paragraph id="par_id250920151936096" role="paragraph" xml-lang="en-US"><item 
type="input">=AVERAGEIF(A2:A6;"pen.*";B2:B6)</item></paragraph>
-<paragraph id="par_id26959239098104" role="paragraph" xml-lang="en-US">The 
function searches what cells from the range A2:A6 begin with “pen” ending 
with any quantity of other symbols, and calculates the average of corresponding 
values from the B2:B6 range. Returns 27.5, because now also “pencil” 
satisfies the condition, and both, first and second rows participate in the 
calculation. </paragraph>
+<paragraph id="par_id26959239098104" role="paragraph" xml-lang="en-US">The 
function searches what cells from the range A2:A6 begin with “pen” ending 
with any quantity of other characters, and calculates the average of 
corresponding values from the B2:B6 range. Returns 27.5, because now also 
“pencil” satisfies the condition, and both, first and second rows 
participate in the calculation. </paragraph>
 <paragraph id="par_id2509201519361352" role="paragraph" xml-lang="en-US"><item 
type="input">=AVERAGEIF(A2:A6;".*book.*";B2:B6)</item></paragraph>
-<paragraph id="par_id227041304619482" role="paragraph" xml-lang="en-US">The 
function searches what cells from the range A2:A6 contain “book” starting 
and ending with any quantity of other symbols, and calculates the average of 
corresponding values from the B2:B6 range. Returns 18.5, because only third and 
fourth rows participate in the calculation.</paragraph>
+<paragraph id="par_id227041304619482" role="paragraph" xml-lang="en-US">The 
function searches what cells from the range A2:A6 contain “book” starting 
and ending with any quantity of other characters, and calculates the average of 
corresponding values from the B2:B6 range. Returns 18.5, because only third and 
fourth rows participate in the calculation.</paragraph>
 <paragraph id="hd_id251309885188" role="heading" level="4" 
xml-lang="en-US">Reference to a cell as a criterion</paragraph>
 <paragraph id="par_id177972099720424" role="paragraph" xml-lang="en-US">If you 
need to change a criterion easily, you may want to specify it in a separate 
cell and use a reference to this cell in the condition of AVERAGEIF function. 
</paragraph>
 <paragraph id="par_id134941261230060" role="paragraph" xml-lang="en-US"><item 
type="input">=AVERAGEIF(A2:A6;".*"&amp;E2&amp;".*";B2:B6)</item></paragraph>
-<paragraph id="par_id172572288310247" role="paragraph" xml-lang="en-US">The 
function searches what cells from the range A2:A6 contain a combination of 
symbols specified in E2 starting and ending with any quantity of other symbols, 
and calculates the average of corresponding values from the B2:B6 range. If E2 
= book, the function returns 18.5.</paragraph>
+<paragraph id="par_id172572288310247" role="paragraph" xml-lang="en-US">The 
function searches what cells from the range A2:A6 contain a combination of 
characters specified in E2 starting and ending with any quantity of other 
characters, and calculates the average of corresponding values from the B2:B6 
range. If E2 = book, the function returns 18.5.</paragraph>
 <paragraph id="par_id316901523627285" role="paragraph" xml-lang="en-US"><item 
type="input">=AVERAGEIF(B2:B6;"&lt;"&amp;E2;C2:C6)</item></paragraph>
 <paragraph id="par_id302181300528607" role="paragraph" xml-lang="en-US">The 
function searches what cells from the range B2:B6 are less than the value 
specified in E2, and calculates the average of corresponding values from the 
C2:C6 range. If E2 = 35, the function returns 145.</paragraph>
 <section id="relatedtopics">

_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits

Reply via email to