04060105.xhp (1aeb69bd) 04060105.xhp (bd727bc8)
1<?xml version="1.0" encoding="UTF-8"?>
2<helpdocument version="1.0">
3
4<!--***********************************************************
5 *
6 * Licensed to the Apache Software Foundation (ASF) under one
7 * or more contributor license agreements. See the NOTICE file
8 * distributed with this work for additional information

--- 9 unchanged lines hidden (view full) ---

18 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
19 * KIND, either express or implied. See the License for the
20 * specific language governing permissions and limitations
21 * under the License.
22 *
23 ***********************************************************-->
24
25
1<?xml version="1.0" encoding="UTF-8"?>
2<helpdocument version="1.0">
3
4<!--***********************************************************
5 *
6 * Licensed to the Apache Software Foundation (ASF) under one
7 * or more contributor license agreements. See the NOTICE file
8 * distributed with this work for additional information

--- 9 unchanged lines hidden (view full) ---

18 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
19 * KIND, either express or implied. See the License for the
20 * specific language governing permissions and limitations
21 * under the License.
22 *
23 ***********************************************************-->
24
25
26
27
26
27
28<meta>
29 <topic id="textscalc0104060105xml" indexer="include">
30 <title xml-lang="en-US" id="tit">Logical Functions</title>
31 <filename>/text/scalc/01/04060105.xhp</filename>
32 </topic>
33 </meta>
34 <body>
35<bookmark xml-lang="en-US" branch="index" id="bm_id3153484"><bookmark_value>logical functions</bookmark_value>
36 <bookmark_value>Function Wizard; logical</bookmark_value>
37 <bookmark_value>functions; logical functions</bookmark_value>
38</bookmark>
39<paragraph xml-lang="en-US" id="hd_id3153484" role="heading" level="1" l10n="U" oldref="1">Logical Functions</paragraph>
28<meta>
29 <topic id="textscalc0104060105xml" indexer="include">
30 <title xml-lang="en-US" id="tit">Logical Functions</title>
31 <filename>/text/scalc/01/04060105.xhp</filename>
32 </topic>
33 </meta>
34 <body>
35<bookmark xml-lang="en-US" branch="index" id="bm_id3153484"><bookmark_value>logical functions</bookmark_value>
36 <bookmark_value>Function Wizard; logical</bookmark_value>
37 <bookmark_value>functions; logical functions</bookmark_value>
38</bookmark>
39<paragraph xml-lang="en-US" id="hd_id3153484" role="heading" level="1" l10n="U" oldref="1">Logical Functions</paragraph>
40 <paragraph xml-lang="en-US" id="par_id3149312" role="paragraph" l10n="U" oldref="2"><variable id="logischtext">This category contains the <emph>Logical</emph> functions.
40 <paragraph xml-lang="en-US" id="par_id3149312" role="paragraph" l10n="U" oldref="2"><variable id="logischtext">This category contains the <emph>Logical</emph> functions.
41</variable></paragraph>
42 <section id="howtoget">
43 <embed href="text/scalc/00/00000404.xhp#eikalo"/>
44 </section>
45<sort order="asc">
46<section id="Section6">
47<bookmark xml-lang="en-US" branch="index" id="bm_id3147505"><bookmark_value>AND function</bookmark_value>
48</bookmark>

--- 122 unchanged lines hidden (view full) ---

171<paragraph xml-lang="en-US" id="hd_id3148394K" role="heading" level="2" l10n="U">XOR</paragraph>
172 <paragraph xml-lang="en-US" id="par_id3156060K" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_ODER">Returns the exclusive "or" of arguments.</ahelp></paragraph>
173 <paragraph xml-lang="en-US" id="par_id3148771K" role="paragraph" l10n="U" oldref="62">The arguments are either numbers, logical expressions themselves (TRUE, 1&lt;5, 2+3=7, B8&lt;10) that return logical values, or arrays (A1:C3).</paragraph>
174 <paragraph xml-lang="en-US" id="par_id3149027K" role="note" l10n="CHG">If the entered range is outside of the current column or row of the formula, the function returns the error value #VALUE!</paragraph>
175 <paragraph xml-lang="en-US" id="hd_id3155517K" role="heading" level="3" l10n="U"
176 oldref="22">Syntax</paragraph>
177 <paragraph xml-lang="en-US" id="par_id3150468K" role="code" l10n="U">XOR(Value1; Value2 ...Value30)</paragraph>
178 <paragraph xml-lang="en-US" id="par_id3155819K" role="paragraph" l10n="CHG" oldref="24">
41</variable></paragraph>
42 <section id="howtoget">
43 <embed href="text/scalc/00/00000404.xhp#eikalo"/>
44 </section>
45<sort order="asc">
46<section id="Section6">
47<bookmark xml-lang="en-US" branch="index" id="bm_id3147505"><bookmark_value>AND function</bookmark_value>
48</bookmark>

--- 122 unchanged lines hidden (view full) ---

171<paragraph xml-lang="en-US" id="hd_id3148394K" role="heading" level="2" l10n="U">XOR</paragraph>
172 <paragraph xml-lang="en-US" id="par_id3156060K" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_ODER">Returns the exclusive "or" of arguments.</ahelp></paragraph>
173 <paragraph xml-lang="en-US" id="par_id3148771K" role="paragraph" l10n="U" oldref="62">The arguments are either numbers, logical expressions themselves (TRUE, 1&lt;5, 2+3=7, B8&lt;10) that return logical values, or arrays (A1:C3).</paragraph>
174 <paragraph xml-lang="en-US" id="par_id3149027K" role="note" l10n="CHG">If the entered range is outside of the current column or row of the formula, the function returns the error value #VALUE!</paragraph>
175 <paragraph xml-lang="en-US" id="hd_id3155517K" role="heading" level="3" l10n="U"
176 oldref="22">Syntax</paragraph>
177 <paragraph xml-lang="en-US" id="par_id3150468K" role="code" l10n="U">XOR(Value1; Value2 ...Value30)</paragraph>
178 <paragraph xml-lang="en-US" id="par_id3155819K" role="paragraph" l10n="CHG" oldref="24">
179
180 <emph>Value1; Value2 ...Value30</emph> are are added modulo 2. TRUE is returned if the result of this addition is
181 1; FALSE is returned if the result of this addition is 0.<comment>UFI: first try to fix bugtraq 4905779</comment></paragraph>
179
180<emph>Value1; Value2 ...Value30</emph> are added modulo 2. TRUE is returned if the result of this addition is 1;
181FALSE is returned if the result of this addition is 0.<comment>UFI: first try to fix bugtraq 4905779</comment></paragraph>
182 <paragraph xml-lang="en-US" id="hd_id3153228K" role="heading" level="3" l10n="U">Examples:</paragraph>
182 <paragraph xml-lang="en-US" id="hd_id3153228K" role="heading" level="3" l10n="U">Examples:</paragraph>
183
183
184 <paragraph xml-lang="en-US" id="par_id3155371K" role="paragraph" l10n="U">
185 <item type="input">=XOR(12&lt;11;13&gt;22;10)</item> returns TRUE since this converts to (1+0+10) mod 2 = 0 </paragraph>
186 <paragraph xml-lang="en-US" id="par_id3158412K" role="paragraph" l10n="U">
187 <item type="input">=XOR(FALSE;TRUE)</item> returns TRUE.</paragraph>
184 <paragraph xml-lang="en-US" id="par_id3155371K" role="paragraph" l10n="U">
185 <item type="input">=XOR(12&lt;11;13&gt;22;10)</item> returns TRUE since this converts to (1+0+10) mod 2 = 0 </paragraph>
186 <paragraph xml-lang="en-US" id="par_id3158412K" role="paragraph" l10n="U">
187 <item type="input">=XOR(FALSE;TRUE)</item> returns TRUE.</paragraph>
188 </section>
188</section>
189</sort>
190<section id="relatedtopics">
191 <embed href="text/scalc/01/04060100.xhp#drking"/>
192 </section>
193 </body>
194</helpdocument>
189</sort>
190<section id="relatedtopics">
191 <embed href="text/scalc/01/04060100.xhp#drking"/>
192 </section>
193 </body>
194</helpdocument>