diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-03-12 18:37:52 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-03-14 11:48:49 +0100 |
| commit | 781da1e8175459f27cca84bed2ca209b3e030067 (patch) | |
| tree | 95386361cfdce2508a0ed43a75b2e23dc279b0d6 | |
| parent | 770c0c1746b5c0b94dc07d5f1d6c2c04802c8540 (diff) | |
tdf#99611 improve function AND() documentation
Added details on handling non logical arguments in
Calc logical functions.
Change-Id: I416fbe9443777a7a7bdfa9d3f61bdf072aff476b
Reviewed-on: https://gerrit.libreoffice.org/51176
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
| -rw-r--r-- | source/text/scalc/01/04060105.xhp | 26 |
1 files changed, 22 insertions, 4 deletions
diff --git a/source/text/scalc/01/04060105.xhp b/source/text/scalc/01/04060105.xhp index 6a5b3032de..983053c997 100644 --- a/source/text/scalc/01/04060105.xhp +++ b/source/text/scalc/01/04060105.xhp @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="UTF-8"?> <helpdocument version="1.0"> - + <!-- * This file is part of the LibreOffice project. * @@ -18,8 +18,8 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - + + <meta> <topic id="textscalc0104060105xml" indexer="include"> <title xml-lang="en-US" id="tit">Logical Functions</title> @@ -32,8 +32,26 @@ <bookmark_value>functions; logical functions</bookmark_value> </bookmark> <paragraph xml-lang="en-US" id="hd_id3153484" role="heading" level="1">Logical Functions</paragraph> - <paragraph xml-lang="en-US" id="par_id3149312" role="paragraph"><variable id="logischtext">This category contains the <emph>Logical</emph> functions. + <paragraph xml-lang="en-US" id="par_id3149312" role="paragraph"><variable id="logischtext">This category contains the <emph>Logical</emph> functions. </variable></paragraph> +<paragraph role="heading" id="hd_id631520887352751" level="3" xml-lang="en-US">Handling non-logical arguments in logical functions</paragraph> +<list type="unordered"> + <listitem> + <paragraph id="par_id431520887384579" role="listitem" xml-lang="en-US">Zero (0) is equivalent to FALSE and all other numbers are equivalent to TRUE.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id881520887475288" role="listitem" xml-lang="en-US">Empty cells and text in cells are ignored.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id461520887504085" role="listitem" xml-lang="en-US">A #VALUE error is raised if all arguments are ignored.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id591520888006686" role="listitem" xml-lang="en-US">A #VALUE error is raised if one argument is direct text (not text in a cell).</paragraph> + </listitem> + <listitem> + <paragraph id="par_id321520889630477" role="listitem" xml-lang="en-US">Errors as argument lead to an error.</paragraph> + </listitem> +</list> <section id="howtoget"> <embed href="text/scalc/00/00000404.xhp#eikalo"/> </section> |