| 04060105.xhp (8e9b354d) | 04060105.xhp (a8d6fec8) |
|---|---|
| 1<?xml version="1.0" encoding="UTF-8"?> 2 3<!--*********************************************************** 4 * 5 * Licensed to the Apache Software Foundation (ASF) under one 6 * or more contributor license agreements. See the NOTICE file 7 * distributed with this work for additional information 8 * regarding copyright ownership. The ASF licenses this file --- 159 unchanged lines hidden (view full) --- 168<paragraph xml-lang="en-US" id="hd_id3148394K" role="heading" level="2" l10n="U">XOR</paragraph> 169<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> 170<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> 171<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> 172<paragraph xml-lang="en-US" id="hd_id3155517K" role="heading" level="3" l10n="U" 173oldref="22">Syntax</paragraph> 174<paragraph xml-lang="en-US" id="par_id3150468K" role="code" l10n="U">XOR(Value1; Value2 ...Value30)</paragraph> 175<paragraph xml-lang="en-US" id="par_id3155819K" role="paragraph" l10n="CHG" oldref="24"> | 1<?xml version="1.0" encoding="UTF-8"?> 2 3<!--*********************************************************** 4 * 5 * Licensed to the Apache Software Foundation (ASF) under one 6 * or more contributor license agreements. See the NOTICE file 7 * distributed with this work for additional information 8 * regarding copyright ownership. The ASF licenses this file --- 159 unchanged lines hidden (view full) --- 168<paragraph xml-lang="en-US" id="hd_id3148394K" role="heading" level="2" l10n="U">XOR</paragraph> 169<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> 170<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> 171<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> 172<paragraph xml-lang="en-US" id="hd_id3155517K" role="heading" level="3" l10n="U" 173oldref="22">Syntax</paragraph> 174<paragraph xml-lang="en-US" id="par_id3150468K" role="code" l10n="U">XOR(Value1; Value2 ...Value30)</paragraph> 175<paragraph xml-lang="en-US" id="par_id3155819K" role="paragraph" l10n="CHG" oldref="24"> |
| 176<emph>Value1; Value2 ... Value30</emph> are added modulo 2. TRUE is returned if the result of this addition is 1; | 176<emph>Value1; Value2 ...Value30</emph> are added modulo 2. TRUE is returned if the result of this addition is 1; |
| 177FALSE is returned if the result of this addition is 0.<comment>UFI: first try to fix bugtraq 4905779</comment></paragraph> 178<paragraph xml-lang="en-US" id="hd_id3153228K" role="heading" level="3" l10n="U">Examples:</paragraph> 179<paragraph xml-lang="en-US" id="par_id3155371K" role="paragraph" l10n="U"> 180<item type="input">=XOR(12<11;13>22;10)</item> returns TRUE since this converts to (1+0+10) mod 2 = 0</paragraph> 181<paragraph xml-lang="en-US" id="par_id3158412K" role="paragraph" l10n="U"> 182<item type="input">=XOR(FALSE;TRUE)</item> returns TRUE.</paragraph> 183</section> 184</sort> 185<section id="relatedtopics"> 186<embed href="text/scalc/01/04060100.xhp#drking"/> 187</section> 188</body> 189</helpdocument> | 177FALSE is returned if the result of this addition is 0.<comment>UFI: first try to fix bugtraq 4905779</comment></paragraph> 178<paragraph xml-lang="en-US" id="hd_id3153228K" role="heading" level="3" l10n="U">Examples:</paragraph> 179<paragraph xml-lang="en-US" id="par_id3155371K" role="paragraph" l10n="U"> 180<item type="input">=XOR(12<11;13>22;10)</item> returns TRUE since this converts to (1+0+10) mod 2 = 0</paragraph> 181<paragraph xml-lang="en-US" id="par_id3158412K" role="paragraph" l10n="U"> 182<item type="input">=XOR(FALSE;TRUE)</item> returns TRUE.</paragraph> 183</section> 184</sort> 185<section id="relatedtopics"> 186<embed href="text/scalc/01/04060100.xhp#drking"/> 187</section> 188</body> 189</helpdocument> |