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<5, 2+3=7, B8<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<5, 2+3=7, B8<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<11;13>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<11;13>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> |