diff options
| author | Stanislav Horacek <stanislav.horacek@gmail.com> | 2015-12-29 22:05:46 +0100 |
|---|---|---|
| committer | Adolfo Jayme Barrientos <fitojb@ubuntu.com> | 2015-12-29 23:11:01 +0000 |
| commit | 0f00c50e4c719fede7d5602e3d29d395bfaf26d6 (patch) | |
| tree | c10047c8cf355ccb24f7a0b3444b973c0dbdcf48 /source/text/scalc | |
| parent | 78c7e1c24aacacfa69c8de3644b154e98d858f7e (diff) | |
AVERAGEIF: fix example
Change-Id: I31fa85189ab4bb24d91e0a0366b08868121b8d47
Reviewed-on: https://gerrit.libreoffice.org/21006
Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
Diffstat (limited to 'source/text/scalc')
| -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 5bbf17616a..277abb625d 100644 --- a/source/text/scalc/01/func_averageif.xhp +++ b/source/text/scalc/01/func_averageif.xhp @@ -62,8 +62,8 @@ If the whole range is empty, contains only text or all values of the range do no <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;".*"&E2&".*";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_id316901523627285" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(A2:A6;"<"&E2;B2:B6)</item></paragraph> -<paragraph id="par_id302181300528607" role="paragraph" xml-lang="en-US">The function searches what cells from the range A2:A6 are less than the value specified in E2, and calculates the average of corresponding values from the B2:B6 range. If E2 = 35, the function returns 145.</paragraph> +<paragraph id="par_id316901523627285" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(B2:B6;"<"&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"> <paragraph id="par_id171371269326270" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060184.xhp#average">AVERAGE</link>, <link href="text/scalc/01/04060184.xhp#averagea">AVERAGEA</link>, <embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>, <link href="text/scalc/01/04060184.xhp#max">MAX</link>, <link href="text/scalc/01/04060184.xhp#min">MIN</link>, <link href="text/scalc/01/04060183.xhp#large">LARGE</link>, <link href="text/scalc/01/04060183.xhp#small">SMALL</link></paragraph> <paragraph id="par_id251321802714497" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph> |