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&gt;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&gt;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&lt;11;13&gt;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&lt;11;13&gt;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>