diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060105.xhp')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/04060105.xhp | 45 |
1 files changed, 27 insertions, 18 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060105.xhp b/helpcontent2/source/text/scalc/01/04060105.xhp index 9310ccc9ac..9932822ffe 100644 --- a/helpcontent2/source/text/scalc/01/04060105.xhp +++ b/helpcontent2/source/text/scalc/01/04060105.xhp @@ -1,9 +1,8 @@ <?xml version="1.0" encoding="UTF-8"?> - - - +<helpdocument version="1.0"> + <!-- - *********************************************************************** +*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * @@ -12,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: 04060105.xhp,v $ - * $Revision: 1.9 $ + * $Revision: 1.9.4.1 $ * * This file is part of OpenOffice.org. * @@ -33,11 +32,10 @@ * ************************************************************************ --> - - - <helpdocument version="1.0"> + + <meta> -<topic id="textscalc0104060105xml" indexer="include" status="PUBLISH"> +<topic id="textscalc0104060105xml" indexer="include"> <title id="tit" xml-lang="en-US">Logical Functions</title> <filename>/text/scalc/01/04060105.xhp</filename> </topic> @@ -51,12 +49,14 @@ <paragraph role="paragraph" id="par_id3149312" xml-lang="en-US" l10n="U" oldref="2"><variable id="logischtext">This category contains the <emph>Logical</emph> functions. </variable></paragraph> <section id="howtoget"> - <embed href="text/scalc/00/00000404.xhp#eikalo"/> +<embed href="text/scalc/00/00000404.xhp#eikalo"/> </section> -<sort order="asc"><section id="Section6"> +<sort order="asc"> +<section id="Section6"> <bookmark xml-lang="en-US" branch="index" id="bm_id3147505"><bookmark_value>AND function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_UND" id="bm_id3145320" localize="false"/><paragraph role="heading" id="hd_id3147505" xml-lang="en-US" level="2" l10n="U" oldref="29">AND</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_UND" id="bm_id3145320" localize="false"/> +<paragraph role="heading" id="hd_id3147505" xml-lang="en-US" level="2" l10n="U" oldref="29">AND</paragraph> <paragraph role="paragraph" id="par_id3153959" xml-lang="en-US" l10n="U" oldref="65"><ahelp hid="HID_FUNC_UND">Returns TRUE if all arguments are TRUE.</ahelp> If one of the elements is FALSE, this function returns the FALSE value.</paragraph> <paragraph role="paragraph" id="par_id3146100" xml-lang="en-US" l10n="U" oldref="66">The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values.</paragraph> <paragraph role="note" id="par_id3150538" xml-lang="en-US" l10n="CHG" oldref="67">When a function expects a single value, but you entered a cell range, then the value from the cell range is taken that is in the same column or row as the formula.<comment>UFI: fixed #i18547#</comment></paragraph> @@ -75,7 +75,8 @@ <section id="Section5"> <bookmark xml-lang="en-US" branch="index" id="bm_id3149015"><bookmark_value>FALSE function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_FALSCH" id="bm_id3154678" localize="false"/><paragraph role="heading" id="hd_id3149015" xml-lang="en-US" level="2" l10n="U" oldref="3">FALSE</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_FALSCH" id="bm_id3154678" localize="false"/> +<paragraph role="heading" id="hd_id3149015" xml-lang="en-US" level="2" l10n="U" oldref="3">FALSE</paragraph> <paragraph role="paragraph" id="par_id3149890" xml-lang="en-US" l10n="U" oldref="4"><ahelp hid="HID_FUNC_FALSCH">Returns the logical value FALSE.</ahelp> The FALSE() function does not require any arguments, and always returns the logical value FALSE.</paragraph> <paragraph role="heading" id="hd_id3146939" xml-lang="en-US" level="3" l10n="U" oldref="5">Syntax</paragraph> <paragraph role="code" id="par_id3150030" xml-lang="en-US" l10n="U" oldref="6">FALSE()</paragraph> @@ -88,7 +89,8 @@ <section id="Section4"> <bookmark xml-lang="en-US" branch="index" id="bm_id3150141"><bookmark_value>IF function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_WENN" id="bm_id3152789" localize="false"/><paragraph role="heading" id="hd_id3150141" xml-lang="en-US" level="2" l10n="U" oldref="48">IF</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_WENN" id="bm_id3152789" localize="false"/> +<paragraph role="heading" id="hd_id3150141" xml-lang="en-US" level="2" l10n="U" oldref="48">IF</paragraph> <paragraph role="paragraph" id="par_id3148740" xml-lang="en-US" l10n="U" oldref="49"><ahelp hid="HID_FUNC_WENN">Specifies a logical test to be performed.</ahelp></paragraph> <paragraph role="heading" id="hd_id3153325" xml-lang="en-US" level="3" l10n="U" oldref="50">Syntax</paragraph> <paragraph role="code" id="par_id3154558" xml-lang="en-US" l10n="U" oldref="51">IF(Test; ThenValue; "OtherwiseValue")</paragraph> @@ -108,7 +110,8 @@ <section id="Section3"> <bookmark xml-lang="en-US" branch="index" id="bm_id3155954"><bookmark_value>NOT function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_NICHT" id="bm_id3145168" localize="false"/><paragraph role="heading" id="hd_id3155954" xml-lang="en-US" level="2" l10n="U" oldref="12">NOT</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_NICHT" id="bm_id3145168" localize="false"/> +<paragraph role="heading" id="hd_id3155954" xml-lang="en-US" level="2" l10n="U" oldref="12">NOT</paragraph> <paragraph role="paragraph" id="par_id3153570" xml-lang="en-US" l10n="U" oldref="13"><ahelp hid="HID_FUNC_NICHT">Reverses the logical value.</ahelp></paragraph> <paragraph role="heading" id="hd_id3147372" xml-lang="en-US" level="3" l10n="U" oldref="14">Syntax</paragraph> <paragraph role="code" id="par_id3157996" xml-lang="en-US" l10n="U" oldref="15">NOT(LogicalValue)</paragraph> @@ -121,7 +124,8 @@ <section id="Section2"> <bookmark xml-lang="en-US" branch="index" id="bm_id3148394"><bookmark_value>OR function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ODER" id="bm_id3155620" localize="false"/><paragraph role="heading" id="hd_id3148394" xml-lang="en-US" level="2" l10n="U" oldref="20">OR</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ODER" id="bm_id3155620" localize="false"/> +<paragraph role="heading" id="hd_id3148394" xml-lang="en-US" level="2" l10n="U" oldref="20">OR</paragraph> <paragraph role="paragraph" id="par_id3156060" xml-lang="en-US" l10n="U" oldref="61"><ahelp hid="HID_FUNC_ODER">Returns TRUE if at least one argument is TRUE.</ahelp> This function returns the value FALSE, if all the arguments have the logical value FALSE.</paragraph> <paragraph role="paragraph" id="par_id3148771" xml-lang="en-US" l10n="U" oldref="62">The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values.</paragraph> <paragraph role="note" id="par_id3153546" xml-lang="en-US" l10n="CHG" oldref="63">When a function expects a single value, but you entered a cell range, then the value from the cell range is taken that is in the same column or row as the formula.</paragraph> @@ -140,7 +144,8 @@ <section id="Section1"> <bookmark xml-lang="en-US" branch="index" id="bm_id3156256"><bookmark_value>TRUE function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_WAHR" id="bm_id3148426" localize="false"/><paragraph role="heading" id="hd_id3156256" xml-lang="en-US" level="2" l10n="U" oldref="38">TRUE</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_WAHR" id="bm_id3148426" localize="false"/> +<paragraph role="heading" id="hd_id3156256" xml-lang="en-US" level="2" l10n="U" oldref="38">TRUE</paragraph> <paragraph role="paragraph" id="par_id3155985" xml-lang="en-US" l10n="U" oldref="39"><ahelp hid="HID_FUNC_WAHR">The logical value is set to TRUE.</ahelp> The TRUE() function does not require any arguments, and always returns the logical value TRUE.</paragraph> <paragraph role="heading" id="hd_id3153717" xml-lang="en-US" level="3" l10n="U" oldref="40">Syntax</paragraph> <paragraph role="code" id="par_id3152590" xml-lang="en-US" l10n="U" oldref="41">TRUE()</paragraph> @@ -153,5 +158,9 @@ <paragraph role="paragraph" id="par_id3154314" xml-lang="en-US" l10n="U" oldref="46"> <item type="input">=NOT(AND(A;B))</item> returns TRUE</paragraph> </section> -</sort></body> +</sort> +<section id="relatedtopics"> +<embed href="text/scalc/01/04060100.xhp#drking"/> +</section> +</body> </helpdocument> |