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:54 +0200 |
commit | e7e056ade1c2aa65aa7d1b9e6453735011886707 (patch) | |
tree | 61e92b09be7b0616c5b8f85f31ea26ee55b03eb7 /source/text/scalc/01/04060181.xhp | |
parent | 7a7b8fc05994922fe3233e80c79110012e2b11da (diff) |
Improve 'IFS documentation
COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS, MINIFS
Improve collateral file
Change-Id: I0573b4df1b7fdc5b656100756e98468bc2a0edf7
Reviewed-on: https://gerrit.libreoffice.org/56311
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01/04060181.xhp')
-rw-r--r-- | source/text/scalc/01/04060181.xhp | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp index 1909e4b56e..df8f67f535 100644 --- a/source/text/scalc/01/04060181.xhp +++ b/source/text/scalc/01/04060181.xhp @@ -62,7 +62,7 @@ <comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ANZAHL" id="bm_id3153040" localize="false"/> -<paragraph id="hd_id3148437" role="heading" level="2" xml-lang="en-US">COUNT</paragraph> +<paragraph id="hd_id3148437" role="heading" level="2" xml-lang="en-US"><variable id="count_head"><link href="text/scalc/01/04060181.xhp#count">COUNT</link></variable></paragraph> <paragraph id="par_id3150700" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ANZAHL">Counts how many numbers are in the list of arguments.</ahelp> Text entries are ignored.</paragraph> <paragraph id="hd_id3153930" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> @@ -82,7 +82,7 @@ <comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ANZAHL2" id="bm_id3148738" localize="false"/> -<paragraph id="hd_id3149729" role="heading" level="2" xml-lang="en-US">COUNTA</paragraph> +<paragraph id="hd_id3149729" role="heading" level="2" xml-lang="en-US"><variable id="counta_head"><link href="text/scalc/01/04060181.xhp#counta">COUNTA</link></variable></paragraph> <paragraph id="par_id3150142" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ANZAHL2">Counts how many values are in the list of arguments.</ahelp> Text entries are also counted, even when they contain an empty string of length 0. If an argument is an array or reference, empty cells within the array or reference are ignored.<comment>UFI: fix to #i35888#</comment></paragraph> <paragraph id="hd_id3148573" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> @@ -103,7 +103,7 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ANZAHLLEEREZELLEN" id="bm_id3149730" localize="false"/> -<paragraph id="hd_id3150896" role="heading" level="2" xml-lang="en-US">COUNTBLANK</paragraph> +<paragraph id="hd_id3150896" role="heading" level="2" xml-lang="en-US"><variable id="countblank_head"><link href="text/scalc/01/04060181.xhp#countblank">COUNTBLANK</link></variable></paragraph> <paragraph id="par_id3155260" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ANZAHLLEEREZELLEN">Returns the number of empty cells.</ahelp></paragraph> <paragraph id="hd_id3145144" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> @@ -122,7 +122,7 @@ <comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZAEHLENWENN" id="bm_id3164909" localize="false"/> -<paragraph id="hd_id3164897" role="heading" level="2" xml-lang="en-US">COUNTIF</paragraph> +<paragraph id="hd_id3164897" role="heading" level="2" xml-lang="en-US"><variable id="countif_head"><link href="text/scalc/01/04060181.xhp#countif">COUNTIF</link></variable></paragraph> <paragraph id="par_id3164926" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ZAEHLENWENN">Returns the number of cells that meet with certain criteria within a cell range.</ahelp></paragraph> <embed href="text/shared/00/00000001.xhp#regulaer"/> |