04060105.xhp (9471d491) | 04060105.xhp (1aeb69bd) |
---|---|
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 --- 71 unchanged lines hidden (view full) --- 80 oldref="42">Example</paragraph> 81 <paragraph xml-lang="en-US" id="par_id3146148" role="paragraph" l10n="U" oldref="43">If A=TRUE and B=FALSE the following examples appear:</paragraph> 82 <paragraph xml-lang="en-US" id="par_id3083285" role="paragraph" l10n="U" oldref="44"> 83 <item type="input">=AND(A;B)</item> returns FALSE</paragraph> 84 <paragraph xml-lang="en-US" id="par_id3083444" role="paragraph" l10n="U" oldref="45"> 85 <item type="input">=OR(A;B)</item> returns TRUE</paragraph> 86 <paragraph xml-lang="en-US" id="par_id3154314" role="paragraph" l10n="U" oldref="46"> 87 <item type="input">=NOT(AND(A;B))</item> returns TRUE</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 --- 71 unchanged lines hidden (view full) --- 80 oldref="42">Example</paragraph> 81 <paragraph xml-lang="en-US" id="par_id3146148" role="paragraph" l10n="U" oldref="43">If A=TRUE and B=FALSE the following examples appear:</paragraph> 82 <paragraph xml-lang="en-US" id="par_id3083285" role="paragraph" l10n="U" oldref="44"> 83 <item type="input">=AND(A;B)</item> returns FALSE</paragraph> 84 <paragraph xml-lang="en-US" id="par_id3083444" role="paragraph" l10n="U" oldref="45"> 85 <item type="input">=OR(A;B)</item> returns TRUE</paragraph> 86 <paragraph xml-lang="en-US" id="par_id3154314" role="paragraph" l10n="U" oldref="46"> 87 <item type="input">=NOT(AND(A;B))</item> returns TRUE</paragraph> |
88 </section> 89 <section id="Section5"> | 88</section> 89<section id="Section5"> |
90<bookmark xml-lang="en-US" branch="index" id="bm_id3149015"><bookmark_value>FALSE function</bookmark_value> 91</bookmark> 92<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FALSCH" id="bm_id3154678" localize="false"/> 93<paragraph xml-lang="en-US" id="hd_id3149015" role="heading" level="2" l10n="U" oldref="3">FALSE</paragraph> 94 <paragraph xml-lang="en-US" id="par_id3149890" role="paragraph" l10n="U" oldref="4"><ahelp hid="HID_FUNC_FALSCH">Returns the logical value FALSE.</ahelp> The FALSE() function does not require any arguments, and always returns the logical value FALSE.</paragraph> 95 <paragraph xml-lang="en-US" id="hd_id3146939" role="heading" level="3" l10n="U" oldref="5">Syntax</paragraph> 96 <paragraph xml-lang="en-US" id="par_id3150030" role="code" l10n="U" oldref="6">FALSE()</paragraph> 97 <paragraph xml-lang="en-US" id="hd_id3150697" role="heading" level="3" l10n="U" oldref="7">Example</paragraph> 98 <paragraph xml-lang="en-US" id="par_id3154842" role="paragraph" l10n="CHG" oldref="8"> 99 <item type="input">=FALSE()</item> returns FALSE</paragraph> 100 <paragraph xml-lang="en-US" id="par_id3147468" role="paragraph" l10n="CHG" oldref="9"> 101 <item type="input">=NOT(FALSE())</item> returns TRUE</paragraph> 102 </section> | 90<bookmark xml-lang="en-US" branch="index" id="bm_id3149015"><bookmark_value>FALSE function</bookmark_value> 91</bookmark> 92<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FALSCH" id="bm_id3154678" localize="false"/> 93<paragraph xml-lang="en-US" id="hd_id3149015" role="heading" level="2" l10n="U" oldref="3">FALSE</paragraph> 94 <paragraph xml-lang="en-US" id="par_id3149890" role="paragraph" l10n="U" oldref="4"><ahelp hid="HID_FUNC_FALSCH">Returns the logical value FALSE.</ahelp> The FALSE() function does not require any arguments, and always returns the logical value FALSE.</paragraph> 95 <paragraph xml-lang="en-US" id="hd_id3146939" role="heading" level="3" l10n="U" oldref="5">Syntax</paragraph> 96 <paragraph xml-lang="en-US" id="par_id3150030" role="code" l10n="U" oldref="6">FALSE()</paragraph> 97 <paragraph xml-lang="en-US" id="hd_id3150697" role="heading" level="3" l10n="U" oldref="7">Example</paragraph> 98 <paragraph xml-lang="en-US" id="par_id3154842" role="paragraph" l10n="CHG" oldref="8"> 99 <item type="input">=FALSE()</item> returns FALSE</paragraph> 100 <paragraph xml-lang="en-US" id="par_id3147468" role="paragraph" l10n="CHG" oldref="9"> 101 <item type="input">=NOT(FALSE())</item> returns TRUE</paragraph> 102 </section> |
103 <section id="Section4"> | 103<section id="Section4"> |
104<bookmark xml-lang="en-US" branch="index" id="bm_id3150141"><bookmark_value>IF function</bookmark_value> 105</bookmark> 106<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WENN" id="bm_id3152789" localize="false"/> 107<paragraph xml-lang="en-US" id="hd_id3150141" role="heading" level="2" l10n="U" 108 oldref="48">IF</paragraph> 109 <paragraph xml-lang="en-US" id="par_id3148740" role="paragraph" l10n="U" oldref="49"><ahelp hid="HID_FUNC_WENN">Specifies a logical test to be performed.</ahelp></paragraph> 110 <paragraph xml-lang="en-US" id="hd_id3153325" role="heading" level="3" l10n="U" 111 oldref="50">Syntax</paragraph> --- 7 unchanged lines hidden (view full) --- 119 <paragraph xml-lang="en-US" id="par_idN107FA" role="paragraph" l10n="NEW"> 120 <embedvar href="text/scalc/00/00000004.xhp#optional"/> 121 </paragraph> 122 <paragraph xml-lang="en-US" id="hd_id3149507" role="heading" level="3" l10n="U" 123 oldref="55">Examples</paragraph> 124 <paragraph xml-lang="en-US" id="par_id3150867" role="paragraph" l10n="U" oldref="57"> 125 <item type="input">=IF(A1>5;100;"too small")</item> If the value in A1 is higher than 5, the value 100 is entered in the current cell; otherwise, the text “too small” (without quotes) is entered.</paragraph> 126 </section> | 104<bookmark xml-lang="en-US" branch="index" id="bm_id3150141"><bookmark_value>IF function</bookmark_value> 105</bookmark> 106<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WENN" id="bm_id3152789" localize="false"/> 107<paragraph xml-lang="en-US" id="hd_id3150141" role="heading" level="2" l10n="U" 108 oldref="48">IF</paragraph> 109 <paragraph xml-lang="en-US" id="par_id3148740" role="paragraph" l10n="U" oldref="49"><ahelp hid="HID_FUNC_WENN">Specifies a logical test to be performed.</ahelp></paragraph> 110 <paragraph xml-lang="en-US" id="hd_id3153325" role="heading" level="3" l10n="U" 111 oldref="50">Syntax</paragraph> --- 7 unchanged lines hidden (view full) --- 119 <paragraph xml-lang="en-US" id="par_idN107FA" role="paragraph" l10n="NEW"> 120 <embedvar href="text/scalc/00/00000004.xhp#optional"/> 121 </paragraph> 122 <paragraph xml-lang="en-US" id="hd_id3149507" role="heading" level="3" l10n="U" 123 oldref="55">Examples</paragraph> 124 <paragraph xml-lang="en-US" id="par_id3150867" role="paragraph" l10n="U" oldref="57"> 125 <item type="input">=IF(A1>5;100;"too small")</item> If the value in A1 is higher than 5, the value 100 is entered in the current cell; otherwise, the text “too small” (without quotes) is entered.</paragraph> 126 </section> |
127 <section id="Section3"> | 127<section id="Section3"> |
128<bookmark xml-lang="en-US" branch="index" id="bm_id3155954"><bookmark_value>NOT function</bookmark_value> 129</bookmark> 130<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NICHT" id="bm_id3145168" localize="false"/> 131<paragraph xml-lang="en-US" id="hd_id3155954" role="heading" level="2" l10n="U" 132 oldref="12">NOT</paragraph> 133 <paragraph xml-lang="en-US" id="par_id3153570" role="paragraph" l10n="CHG" oldref="13"><ahelp hid="HID_FUNC_NICHT">Complements (inverts) a logical value.</ahelp></paragraph> 134 <paragraph xml-lang="en-US" id="hd_id3147372" role="heading" level="3" l10n="U" 135 oldref="14">Syntax</paragraph> --- 44 unchanged lines hidden (view full) --- 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> 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> | 128<bookmark xml-lang="en-US" branch="index" id="bm_id3155954"><bookmark_value>NOT function</bookmark_value> 129</bookmark> 130<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NICHT" id="bm_id3145168" localize="false"/> 131<paragraph xml-lang="en-US" id="hd_id3155954" role="heading" level="2" l10n="U" 132 oldref="12">NOT</paragraph> 133 <paragraph xml-lang="en-US" id="par_id3153570" role="paragraph" l10n="CHG" oldref="13"><ahelp hid="HID_FUNC_NICHT">Complements (inverts) a logical value.</ahelp></paragraph> 134 <paragraph xml-lang="en-US" id="hd_id3147372" role="heading" level="3" l10n="U" 135 oldref="14">Syntax</paragraph> --- 44 unchanged lines hidden (view full) --- 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> 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> |
188 </section> 189 <section id="Section1"> 190<bookmark xml-lang="en-US" branch="index" id="bm_id3156256"><bookmark_value>TRUE function</bookmark_value> 191</bookmark> 192<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WAHR" id="bm_id3148426" localize="false"/> 193<paragraph xml-lang="en-US" id="hd_id3156256" role="heading" level="2" l10n="U" 194 oldref="38">TRUE</paragraph> 195 <paragraph xml-lang="en-US" id="par_id3155985" role="paragraph" l10n="U" oldref="39"><ahelp hid="HID_FUNC_WAHR">The logical value is set to TRUE.</ahelp> The TRUE() function does not require any arguments, and always returns the logical value TRUE.</paragraph> 196 <paragraph xml-lang="en-US" id="hd_id3153717" role="heading" level="3" l10n="U" 197 oldref="40">Syntax</paragraph> 198 <paragraph xml-lang="en-US" id="par_id3152590" role="code" l10n="U" oldref="41">TRUE()</paragraph> 199 <paragraph xml-lang="en-US" id="hd_id3147175" role="heading" level="3" l10n="U" 200 oldref="42">Example</paragraph> 201 <paragraph xml-lang="en-US" id="par_id3146148" role="paragraph" l10n="U" oldref="43">If A=TRUE and B=FALSE the following examples appear:</paragraph> 202 <paragraph xml-lang="en-US" id="par_id3083285" role="paragraph" l10n="U" oldref="44"> 203 <item type="input">=AND(A;B)</item> returns FALSE</paragraph> 204 <paragraph xml-lang="en-US" id="par_id3083444" role="paragraph" l10n="U" oldref="45"> 205 <item type="input">=OR(A;B)</item> returns TRUE</paragraph> 206 <paragraph xml-lang="en-US" id="par_id3154314" role="paragraph" l10n="U" oldref="46"> 207 <item type="input">=NOT(AND(A;B))</item> returns TRUE</paragraph> 208 </section> | 188 </section> |
209</sort> 210<section id="relatedtopics"> 211 <embed href="text/scalc/01/04060100.xhp#drking"/> 212 </section> 213 </body> 214</helpdocument> | 189</sort> 190<section id="relatedtopics"> 191 <embed href="text/scalc/01/04060100.xhp#drking"/> 192 </section> 193 </body> 194</helpdocument> |