04060105.xhp (52ac0773) 04060105.xhp (9471d491)
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

--- 52 unchanged lines hidden (view full) ---

61 <paragraph xml-lang="en-US" id="hd_id3149143" role="heading" level="3" l10n="U"
62 oldref="34">Example</paragraph>
63 <paragraph xml-lang="en-US" id="par_id3153123" role="paragraph" l10n="U" oldref="35">The logical values of entries 12&lt;13; 14&gt;12, and 7&lt;6 are to be checked:</paragraph>
64 <paragraph xml-lang="en-US" id="par_id3145632" role="paragraph" l10n="U" oldref="36">
65 <item type="input">=AND(12&lt;13;14&gt;12;7&lt;6)</item> returns FALSE.</paragraph>
66 <paragraph xml-lang="en-US" id="par_id3149946" role="paragraph" l10n="U" oldref="60">
67 <item type="input">=AND (FALSE;TRUE)</item> returns FALSE.</paragraph>
68 </section>
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

--- 52 unchanged lines hidden (view full) ---

61 <paragraph xml-lang="en-US" id="hd_id3149143" role="heading" level="3" l10n="U"
62 oldref="34">Example</paragraph>
63 <paragraph xml-lang="en-US" id="par_id3153123" role="paragraph" l10n="U" oldref="35">The logical values of entries 12&lt;13; 14&gt;12, and 7&lt;6 are to be checked:</paragraph>
64 <paragraph xml-lang="en-US" id="par_id3145632" role="paragraph" l10n="U" oldref="36">
65 <item type="input">=AND(12&lt;13;14&gt;12;7&lt;6)</item> returns FALSE.</paragraph>
66 <paragraph xml-lang="en-US" id="par_id3149946" role="paragraph" l10n="U" oldref="60">
67 <item type="input">=AND (FALSE;TRUE)</item> returns FALSE.</paragraph>
68 </section>
69<section id="Section1">
70<bookmark xml-lang="en-US" branch="index" id="bm_id3156256"><bookmark_value>TRUE function</bookmark_value>
71</bookmark>
72<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WAHR" id="bm_id3148426" localize="false"/>
73<paragraph xml-lang="en-US" id="hd_id3156256" role="heading" level="2" l10n="U"
74 oldref="38">TRUE</paragraph>
75 <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>
76 <paragraph xml-lang="en-US" id="hd_id3153717" role="heading" level="3" l10n="U"
77 oldref="40">Syntax</paragraph>
78 <paragraph xml-lang="en-US" id="par_id3152590" role="code" l10n="U" oldref="41">TRUE()</paragraph>
79 <paragraph xml-lang="en-US" id="hd_id3147175" role="heading" level="3" l10n="U"
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>
69 <section id="Section5">
70<bookmark xml-lang="en-US" branch="index" id="bm_id3149015"><bookmark_value>FALSE function</bookmark_value>
71</bookmark>
72<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FALSCH" id="bm_id3154678" localize="false"/>
73<paragraph xml-lang="en-US" id="hd_id3149015" role="heading" level="2" l10n="U" oldref="3">FALSE</paragraph>
74 <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>
75 <paragraph xml-lang="en-US" id="hd_id3146939" role="heading" level="3" l10n="U" oldref="5">Syntax</paragraph>
76 <paragraph xml-lang="en-US" id="par_id3150030" role="code" l10n="U" oldref="6">FALSE()</paragraph>
77 <paragraph xml-lang="en-US" id="hd_id3150697" role="heading" level="3" l10n="U" oldref="7">Example</paragraph>
78 <paragraph xml-lang="en-US" id="par_id3154842" role="paragraph" l10n="CHG" oldref="8">
79 <item type="input">=FALSE()</item> returns FALSE</paragraph>
80 <paragraph xml-lang="en-US" id="par_id3147468" role="paragraph" l10n="CHG" oldref="9">
81 <item type="input">=NOT(FALSE())</item> returns TRUE</paragraph>
82 </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>
83 <section id="Section4">
103 <section id="Section4">
84<bookmark xml-lang="en-US" branch="index" id="bm_id3150141"><bookmark_value>IF function</bookmark_value>
85</bookmark>
86<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WENN" id="bm_id3152789" localize="false"/>
87<paragraph xml-lang="en-US" id="hd_id3150141" role="heading" level="2" l10n="U"
88 oldref="48">IF</paragraph>
89 <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>
90 <paragraph xml-lang="en-US" id="hd_id3153325" role="heading" level="3" l10n="U"
91 oldref="50">Syntax</paragraph>

--- 24 unchanged lines hidden (view full) ---

116 <paragraph xml-lang="en-US" id="par_id3157996" role="code" l10n="U" oldref="15">NOT(LogicalValue)</paragraph>
117 <paragraph xml-lang="en-US" id="par_id3148766" role="paragraph" l10n="CHG" oldref="16">
118 <emph>LogicalValue</emph> is any value to be complemented.</paragraph>
119 <paragraph xml-lang="en-US" id="hd_id3149884" role="heading" level="3" l10n="U"
120 oldref="17">Example</paragraph>
121 <paragraph xml-lang="en-US" id="par_id3150132" role="paragraph" l10n="CHG" oldref="18">
122 <item type="input">=NOT(A)</item>. If A=TRUE then NOT(A) will evaluate FALSE.</paragraph>
123 </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>

--- 24 unchanged lines hidden (view full) ---

136 <paragraph xml-lang="en-US" id="par_id3157996" role="code" l10n="U" oldref="15">NOT(LogicalValue)</paragraph>
137 <paragraph xml-lang="en-US" id="par_id3148766" role="paragraph" l10n="CHG" oldref="16">
138 <emph>LogicalValue</emph> is any value to be complemented.</paragraph>
139 <paragraph xml-lang="en-US" id="hd_id3149884" role="heading" level="3" l10n="U"
140 oldref="17">Example</paragraph>
141 <paragraph xml-lang="en-US" id="par_id3150132" role="paragraph" l10n="CHG" oldref="18">
142 <item type="input">=NOT(A)</item>. If A=TRUE then NOT(A) will evaluate FALSE.</paragraph>
143 </section>
124 <section id="Section2">
144<section id="Section2">
125<bookmark xml-lang="en-US" branch="index" id="bm_id3148394"><bookmark_value>OR function</bookmark_value>
126</bookmark>
127<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ODER" id="bm_id3155620" localize="false"/>
128<paragraph xml-lang="en-US" id="hd_id3148394" role="heading" level="2" l10n="U"
129 oldref="20">OR</paragraph>
130 <paragraph xml-lang="en-US" id="par_id3156060" role="paragraph" l10n="U" oldref="61"><ahelp hid="HID_FUNC_ODER">Returns TRUE if at least one argument is TRUE.</ahelp> This function returns the value FALSE, if all the arguments have the logical value FALSE.</paragraph>
131 <paragraph xml-lang="en-US" id="par_id3148771" role="paragraph" l10n="U" oldref="62">The arguments are either logical expressions themselves (TRUE, 1&lt;5, 2+3=7, B8&lt;10) that return logical values, or arrays (A1:C3) containing logical values.</paragraph>
132 <paragraph xml-lang="en-US" id="par_id3153546" role="note" l10n="CHG" oldref="63">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>
133 <paragraph xml-lang="en-US" id="par_id3149027" role="note" l10n="CHG" oldref="64">If the entered range is outside of the current column or row of the formula, the function returns the error value #VALUE!</paragraph>
134 <paragraph xml-lang="en-US" id="hd_id3155517" role="heading" level="3" l10n="U"
135 oldref="22">Syntax</paragraph>
136 <paragraph xml-lang="en-US" id="par_id3150468" role="code" l10n="U" oldref="23">OR(LogicalValue1; LogicalValue2 ...LogicalValue30)</paragraph>
137 <paragraph xml-lang="en-US" id="par_id3155819" role="paragraph" l10n="CHG" oldref="24">
138 <emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses the value from the range that is in the current column or row.<comment>UFI: first try to fix bugtraq 4905779</comment></paragraph>
139 <paragraph xml-lang="en-US" id="hd_id3153228" role="heading" level="3" l10n="U"
145<bookmark xml-lang="en-US" branch="index" id="bm_id3148394"><bookmark_value>OR function</bookmark_value>
146</bookmark>
147<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ODER" id="bm_id3155620" localize="false"/>
148<paragraph xml-lang="en-US" id="hd_id3148394" role="heading" level="2" l10n="U"
149 oldref="20">OR</paragraph>
150 <paragraph xml-lang="en-US" id="par_id3156060" role="paragraph" l10n="U" oldref="61"><ahelp hid="HID_FUNC_ODER">Returns TRUE if at least one argument is TRUE.</ahelp> This function returns the value FALSE, if all the arguments have the logical value FALSE.</paragraph>
151 <paragraph xml-lang="en-US" id="par_id3148771" role="paragraph" l10n="U" oldref="62">The arguments are either logical expressions themselves (TRUE, 1&lt;5, 2+3=7, B8&lt;10) that return logical values, or arrays (A1:C3) containing logical values.</paragraph>
152 <paragraph xml-lang="en-US" id="par_id3153546" role="note" l10n="CHG" oldref="63">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>
153 <paragraph xml-lang="en-US" id="par_id3149027" role="note" l10n="CHG" oldref="64">If the entered range is outside of the current column or row of the formula, the function returns the error value #VALUE!</paragraph>
154 <paragraph xml-lang="en-US" id="hd_id3155517" role="heading" level="3" l10n="U"
155 oldref="22">Syntax</paragraph>
156 <paragraph xml-lang="en-US" id="par_id3150468" role="code" l10n="U" oldref="23">OR(LogicalValue1; LogicalValue2 ...LogicalValue30)</paragraph>
157 <paragraph xml-lang="en-US" id="par_id3155819" role="paragraph" l10n="CHG" oldref="24">
158 <emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses the value from the range that is in the current column or row.<comment>UFI: first try to fix bugtraq 4905779</comment></paragraph>
159 <paragraph xml-lang="en-US" id="hd_id3153228" role="heading" level="3" l10n="U"
140 oldref="25">Example</paragraph>
160 oldref="25">Examples:</paragraph>
141 <paragraph xml-lang="en-US" id="par_id3154870" role="paragraph" l10n="U" oldref="26">The logical values of entries 12&lt;11; 13&gt;22, and 45=45 are to be checked.</paragraph>
142 <paragraph xml-lang="en-US" id="par_id3155371" role="paragraph" l10n="U" oldref="27">
143 <item type="input">=OR(12&lt;11;13&gt;22;45=45)</item> returns TRUE.</paragraph>
144 <paragraph xml-lang="en-US" id="par_id3158412" role="paragraph" l10n="U" oldref="59">
145 <item type="input">=OR(FALSE;TRUE)</item> returns TRUE.</paragraph>
146 </section>
161 <paragraph xml-lang="en-US" id="par_id3154870" role="paragraph" l10n="U" oldref="26">The logical values of entries 12&lt;11; 13&gt;22, and 45=45 are to be checked.</paragraph>
162 <paragraph xml-lang="en-US" id="par_id3155371" role="paragraph" l10n="U" oldref="27">
163 <item type="input">=OR(12&lt;11;13&gt;22;45=45)</item> returns TRUE.</paragraph>
164 <paragraph xml-lang="en-US" id="par_id3158412" role="paragraph" l10n="U" oldref="59">
165 <item type="input">=OR(FALSE;TRUE)</item> returns TRUE.</paragraph>
166 </section>
167<section id="Section7">
168<bookmark xml-lang="en-US" branch="index" id="bm_id3148394K"><bookmark_value>XOR function</bookmark_value>
169</bookmark><comment>kschenk added this entry</comment>
170<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ODER" id="bm_id3155620K" localize="false"/>
171<paragraph xml-lang="en-US" id="hd_id3148394K" role="heading" level="2" l10n="U">XOR</paragraph>
172 <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>
173 <paragraph xml-lang="en-US" id="par_id3148771K" role="paragraph" l10n="U" oldref="62">The arguments are either numbers, logical expressions themselves (TRUE, 1&lt;5, 2+3=7, B8&lt;10) that return logical values, or arrays (A1:C3).</paragraph>
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 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>
147 <section id="Section1">
148<bookmark xml-lang="en-US" branch="index" id="bm_id3156256"><bookmark_value>TRUE function</bookmark_value>
149</bookmark>
150<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WAHR" id="bm_id3148426" localize="false"/>
151<paragraph xml-lang="en-US" id="hd_id3156256" role="heading" level="2" l10n="U"
152 oldref="38">TRUE</paragraph>
153 <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>
154 <paragraph xml-lang="en-US" id="hd_id3153717" role="heading" level="3" l10n="U"

--- 18 unchanged lines hidden ---
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"

--- 18 unchanged lines hidden ---