| 04060105.xhp (bd727bc8) | 04060105.xhp (65523e0f) |
|---|---|
| 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 --- 165 unchanged lines hidden (view full) --- 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 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> | 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 --- 165 unchanged lines hidden (view full) --- 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 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> 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> | 182<paragraph xml-lang="en-US" id="hd_id3153228K" role="heading" level="3" l10n="U">Examples:</paragraph> 183<paragraph xml-lang="en-US" id="par_id3155371K" role="paragraph" l10n="U"> 184<item type="input">=XOR(12<11;13>22;10)</item> returns TRUE since this converts to (1+0+10) mod 2 = 0</paragraph> 185<paragraph xml-lang="en-US" id="par_id3158412K" role="paragraph" l10n="U"> 186<item type="input">=XOR(FALSE;TRUE)</item> returns TRUE.</paragraph> |
| 188</section> 189</sort> 190<section id="relatedtopics"> 191 <embed href="text/scalc/01/04060100.xhp#drking"/> 192 </section> 193 </body> 194</helpdocument> | 187</section> 188</sort> 189<section id="relatedtopics"> 190 <embed href="text/scalc/01/04060100.xhp#drking"/> 191 </section> 192 </body> 193</helpdocument> |