diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-06-22 23:32:13 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-06-23 13:02:35 +0200 |
| commit | 9c72214669c1f04d0e91e4c477c76c44b3aa63b4 (patch) | |
| tree | 7d2c63923f29b9a976628982d581ec8542090194 /source/text/scalc/01/func_averageifs.xhp | |
| parent | 75f676e25ac0062295c5523556e7340af7df33ee (diff) | |
Improve 'IFS documentation
COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS, MINIFS
Improve collateral file
Change-Id: I0573b4df1b7fdc5b656100756e98468bc2a0edf7
Reviewed-on: https://gerrit.libreoffice.org/56310
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01/func_averageifs.xhp')
| -rw-r--r-- | source/text/scalc/01/func_averageifs.xhp | 17 |
1 files changed, 15 insertions, 2 deletions
diff --git a/source/text/scalc/01/func_averageifs.xhp b/source/text/scalc/01/func_averageifs.xhp index 6a38f4e4d8..cd6be6eabc 100644 --- a/source/text/scalc/01/func_averageifs.xhp +++ b/source/text/scalc/01/func_averageifs.xhp @@ -51,9 +51,22 @@ <paragraph id="par_id316794795433" 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 AVERAGEIFS function. For example, the above function can be rewritten as follows:</paragraph> <paragraph id="par_id67531072426731" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIFS(C2:C6;A2:A6;E2&".*";B2:B6;"<"&MAX(B2:B6))</item></paragraph> <paragraph id="par_id65612244926745" role="paragraph" xml-lang="en-US">If E2 = pen, the function returns 65, because the link to the cell is substituted with its content.</paragraph> +<embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/> <section id="relatedtopics"> - <paragraph id="par_id1279148769260" 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_averageif.xhp#averageif_head"/>, <embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/>, <embedvar href="text/scalc/01/func_minifs.xhp#minifs_head"/>, <embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_head"/>, <embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/>, <link href="text/scalc/01/04060184.xhp#max">MAX</link>, <link href="text/scalc/01/04060184.xhp#min">MIN</link></paragraph> -<paragraph id="par_id20741445030307" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph> + <paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US" localize="false"> + <embedvar href="text/scalc/01/04060184.xhp#average_head"/>, + <embedvar href="text/scalc/01/04060184.xhp#averagea_head"/>, + <embedvar href="text/scalc/01/04060184.xhp#avedev_head"/>, + <embedvar href="text/scalc/01/func_averageif.xhp#averageif_head"/> + </paragraph> + <paragraph id="par_id11931178730928" role="paragraph" xml-lang="en-US" localize="false"> + <embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/>, + <embedvar href="text/scalc/01/func_minifs.xhp#minifs_head"/>, + <embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_head"/>, + <embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>, + <embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/> + </paragraph> +<paragraph id="par_id20741445030307" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph> </section> </body> </helpdocument> |