diff options
| author | Andras Timar <andras.timar@collabora.com> | 2013-10-09 08:27:34 +0200 |
|---|---|---|
| committer | Andras Timar <andras.timar@collabora.com> | 2013-10-09 08:27:34 +0200 |
| commit | 0168bad31cf97541695bffec867e078d76abf352 (patch) | |
| tree | bdc8fb7cf1dfff81e98ecff11430fecdc9d84bc0 /source | |
| parent | Correct typo in function DDE in Calc (diff) | |
| download | help-0168bad31cf97541695bffec867e078d76abf352.tar.gz help-0168bad31cf97541695bffec867e078d76abf352.zip | |
fdo#69509 add help for XOR spreadsheet function
Change-Id: Iffaff83a11d77eb1d7c7025930902c0940ee9b24
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/04060105.xhp | 21 |
1 files changed, 20 insertions, 1 deletions
diff --git a/source/text/scalc/01/04060105.xhp b/source/text/scalc/01/04060105.xhp index 4417c1ed6d..98bbffd696 100644 --- a/source/text/scalc/01/04060105.xhp +++ b/source/text/scalc/01/04060105.xhp @@ -159,9 +159,28 @@ <paragraph xml-lang="en-US" id="par_id3154314" role="paragraph" l10n="U" oldref="46"> <item type="input">=NOT(AND(A;B))</item> returns TRUE</paragraph> </section> + <section id="Section0"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3156257"><bookmark_value>XOR function</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_XOR" id="bm_id3148427" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3156257" role="heading" level="2">XOR</paragraph> + <paragraph xml-lang="en-US" id="par_id3155987" role="paragraph"><ahelp hid="HID_FUNC_XOR">Returns true if an odd number of arguments evaluates to TRUE.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="par_id3148772" role="paragraph">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 xml-lang="en-US" id="par_id3153547" role="note">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> + <paragraph xml-lang="en-US" id="par_id3149028" role="note">If the entered range is outside of the current column or row of the formula, the function returns the error value #VALUE!</paragraph> + <paragraph xml-lang="en-US" id="hd_id3153718" role="heading" level="3">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3150469" role="code">XOR(LogicalValue1; LogicalValue2 ...LogicalValue30)</paragraph> + <paragraph xml-lang="en-US" id="hd_id3147176" role="heading" level="3">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3083286" role="paragraph"> + <item type="input">=XOR(TRUE;TRUE)</item> returns FALSE</paragraph> + <paragraph xml-lang="en-US" id="par_id3083445" role="paragraph"> + <item type="input">=XOR(TRUE;TRUE;TRUE)</item> returns TRUE</paragraph> + <paragraph xml-lang="en-US" id="par_id3154315" role="paragraph"> + <item type="input">=XOR(FALSE;TRUE)</item> returns TRUE</paragraph> + </section> </sort> <section id="relatedtopics"> <embed href="text/scalc/01/04060100.xhp#drking"/> </section> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> |