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
9 * regarding copyright ownership.  The ASF licenses this file
10 * to you under the Apache License, Version 2.0 (the
11 * "License"); you may not use this file except in compliance
12 * with the License.  You may obtain a copy of the License at
13 *
14 *   http://www.apache.org/licenses/LICENSE-2.0
15 *
16 * Unless required by applicable law or agreed to in writing,
17 * software distributed under the License is distributed on an
18 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
19 * KIND, either express or implied.  See the License for the
20 * specific language governing permissions and limitations
21 * under the License.
22 *
23 ***********************************************************-->
24
25
26
27
28<meta>
29<topic id="textscalc0104060104xml" indexer="include">
30<title id="tit" xml-lang="en-US">Information Functions</title>
31<filename>/text/scalc/01/04060104.xhp</filename>
32</topic>
33</meta>
34<body>
35<bookmark xml-lang="en-US" branch="index" id="bm_id3147247"><bookmark_value>information functions</bookmark_value>
36<bookmark_value>Function Wizard; information</bookmark_value>
37<bookmark_value>functions; information functions</bookmark_value>
38</bookmark>
39<paragraph role="heading" id="hd_id3147247" xml-lang="en-US" level="1" l10n="U" oldref="1">Information Functions</paragraph>
40<paragraph role="paragraph" id="par_id3147499" xml-lang="en-US" l10n="CHG" oldref="2"><variable id="informationtext">This category contains the <emph>Information</emph> functions.
41</variable></paragraph>
42<section id="howtoget">
43<embed href="text/scalc/00/00000404.xhp#eikain"/>
44</section>
45<paragraph role="paragraph" id="par_id3159128" xml-lang="en-US" l10n="U" oldref="3">The data in the following table serves as the basis for some of the examples in the function descriptions:</paragraph>
46<table id="tbl_id3157876">
47<tablerow>
48<tablecell>
49</tablecell>
50<tablecell>
51<paragraph role="tablehead" id="par_id3146885" xml-lang="en-US" l10n="U" oldref="4">C</paragraph>
52</tablecell>
53<tablecell>
54<paragraph role="tablehead" id="par_id3149944" xml-lang="en-US" l10n="U" oldref="5">D</paragraph>
55</tablecell>
56</tablerow>
57<tablerow>
58<tablecell>
59<paragraph role="tablecontent" id="par_id3150457" xml-lang="en-US" l10n="U" oldref="6">
60<emph>2</emph>
61</paragraph>
62</tablecell>
63<tablecell>
64<paragraph role="tablecontent" id="par_id3150024" xml-lang="en-US" l10n="U" oldref="7">x <item type="input">value</item>
65</paragraph>
66</tablecell>
67<tablecell>
68<paragraph role="tablecontent" id="par_id3148725" xml-lang="en-US" l10n="U" oldref="8">y <item type="input">value</item>
69</paragraph>
70</tablecell>
71</tablerow>
72<tablerow>
73<tablecell>
74<paragraph role="tablecontent" id="par_id3150480" xml-lang="en-US" l10n="U" oldref="9">
75<emph>3</emph>
76</paragraph>
77</tablecell>
78<tablecell>
79<paragraph role="tablecontent" id="par_id3148440" xml-lang="en-US" l10n="U" oldref="10">
80<item type="input">-5</item>
81</paragraph>
82</tablecell>
83<tablecell>
84<paragraph role="tablecontent" id="par_id3148888" xml-lang="en-US" l10n="U" oldref="11">
85<item type="input">-3</item>
86</paragraph>
87</tablecell>
88</tablerow>
89<tablerow>
90<tablecell>
91<paragraph role="tablecontent" id="par_id3153034" xml-lang="en-US" l10n="U" oldref="12">
92<emph>4</emph>
93</paragraph>
94</tablecell>
95<tablecell>
96<paragraph role="tablecontent" id="par_id3150139" xml-lang="en-US" l10n="U" oldref="13">
97<item type="input">-2</item>
98</paragraph>
99</tablecell>
100<tablecell>
101<paragraph role="tablecontent" id="par_id3149542" xml-lang="en-US" l10n="U" oldref="14">
102<item type="input">0</item>
103</paragraph>
104</tablecell>
105</tablerow>
106<tablerow>
107<tablecell>
108<paragraph role="tablecontent" id="par_id3149188" xml-lang="en-US" l10n="U" oldref="15">
109<emph>5</emph>
110</paragraph>
111</tablecell>
112<tablecell>
113<paragraph role="tablecontent" id="par_id3153329" xml-lang="en-US" l10n="U" oldref="16">
114<item type="input">-1</item>
115</paragraph>
116</tablecell>
117<tablecell>
118<paragraph role="tablecontent" id="par_id3155257" xml-lang="en-US" l10n="U" oldref="17">
119<item type="input">1</item>
120</paragraph>
121</tablecell>
122</tablerow>
123<tablerow>
124<tablecell>
125<paragraph role="tablecontent" id="par_id3145142" xml-lang="en-US" l10n="U" oldref="18">
126<emph>6</emph>
127</paragraph>
128</tablecell>
129<tablecell>
130<paragraph role="tablecontent" id="par_id3149956" xml-lang="en-US" l10n="U" oldref="19">
131<item type="input">0</item>
132</paragraph>
133</tablecell>
134<tablecell>
135<paragraph role="tablecontent" id="par_id3145594" xml-lang="en-US" l10n="U" oldref="20">
136<item type="input">3</item>
137</paragraph>
138</tablecell>
139</tablerow>
140<tablerow>
141<tablecell>
142<paragraph role="tablecontent" id="par_id3153113" xml-lang="en-US" l10n="U" oldref="21">
143<emph>7</emph>
144</paragraph>
145</tablecell>
146<tablecell>
147<paragraph role="tablecontent" id="par_id3148573" xml-lang="en-US" l10n="U" oldref="22">
148<item type="input">2</item>
149</paragraph>
150</tablecell>
151<tablecell>
152<paragraph role="tablecontent" id="par_id3145166" xml-lang="en-US" l10n="U" oldref="23">
153<item type="input">4</item>
154</paragraph>
155</tablecell>
156</tablerow>
157<tablerow>
158<tablecell>
159<paragraph role="tablecontent" id="par_id3157998" xml-lang="en-US" l10n="U" oldref="24">
160<emph>8</emph>
161</paragraph>
162</tablecell>
163<tablecell>
164<paragraph role="tablecontent" id="par_id3150018" xml-lang="en-US" l10n="U" oldref="25">
165<item type="input">4</item>
166</paragraph>
167</tablecell>
168<tablecell>
169<paragraph role="tablecontent" id="par_id3150129" xml-lang="en-US" l10n="U" oldref="26">
170<item type="input">6</item>
171</paragraph>
172</tablecell>
173</tablerow>
174<tablerow>
175<tablecell>
176<paragraph role="tablecontent" id="par_id3145245" xml-lang="en-US" l10n="U" oldref="27">
177<emph>9</emph>
178</paragraph>
179</tablecell>
180<tablecell>
181<paragraph role="tablecontent" id="par_id3148389" xml-lang="en-US" l10n="U" oldref="28">
182<item type="input">6</item>
183</paragraph>
184</tablecell>
185<tablecell>
186<paragraph role="tablecontent" id="par_id3156068" xml-lang="en-US" l10n="U" oldref="29">
187<item type="input">8</item>
188</paragraph>
189</tablecell>
190</tablerow>
191</table>
192
193<sort order="asc">
194<section id="info">
195<bookmark xml-lang="en-US" branch="index" id="bm_id3691824"><bookmark_value>INFO function</bookmark_value>
196</bookmark>
197<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_INFO" id="bm_id5369426" localize="false"/>
198<paragraph role="heading" id="hd_id5787224" xml-lang="en-US" level="2" l10n="NEW">INFO</paragraph>
199<paragraph role="paragraph" id="par_id1507309" xml-lang="en-US" l10n="NEW">Returns specific information about the current working environment. The function receives a single text argument and returns data depending on that parameter.</paragraph>
200<paragraph role="heading" id="hd_id7693411" xml-lang="en-US" level="3" l10n="NEW">Syntax</paragraph>
201<paragraph role="code" id="par_id3928952" xml-lang="en-US" l10n="NEW">INFO("Type")</paragraph>
202<paragraph role="paragraph" id="par_id5206762" xml-lang="en-US" l10n="NEW">The following table lists the values for the text parameter <item type="literal">Type</item> and the return values of the INFO function.</paragraph>
203<table id="tbl_id1342204">
204<tablerow>
205<tablecell>
206<paragraph role="tablehead" id="par_id5735953" xml-lang="en-US" l10n="NEW">Value for "Type"<comment>Do not translate the text values in this column below</comment></paragraph>
207</tablecell>
208<tablecell>
209<paragraph role="tablehead" id="par_id8360850" xml-lang="en-US" l10n="NEW">Return value</paragraph>
210</tablecell>
211</tablerow>
212<tablerow>
213<tablecell>
214<paragraph role="tablecontent" id="par_id9648731" xml-lang="en-US" l10n="NEW">"osversion"</paragraph>
215</tablecell>
216<tablecell>
217<paragraph role="tablecontent" id="par_id908841" xml-lang="en-US" l10n="NEW">Always "Windows (32-bit) NT 5.01", for compatibility reasons</paragraph>
218</tablecell>
219</tablerow>
220<tablerow>
221<tablecell>
222<paragraph role="tablecontent" id="par_id8193914" xml-lang="en-US" l10n="NEW">"system"</paragraph>
223</tablecell>
224<tablecell>
225<paragraph role="tablecontent" id="par_id9841608" xml-lang="en-US" l10n="NEW">The type of the operating system. <br/>"WNT" for Microsoft Windows <br/>"LINUX" for Linux <br/>"SOLARIS" for Solaris</paragraph>
226</tablecell>
227</tablerow>
228<tablerow>
229<tablecell>
230<paragraph role="tablecontent" id="par_id2701803" xml-lang="en-US" l10n="NEW">"release"</paragraph>
231</tablecell>
232<tablecell>
233<paragraph role="tablecontent" id="par_id2136295" xml-lang="en-US" l10n="NEW">The product release identifier, for example "300m25(Build:9876)"</paragraph>
234</tablecell>
235</tablerow>
236<tablerow>
237<tablecell>
238<paragraph role="tablecontent" id="par_id9200109" xml-lang="en-US" l10n="NEW">"numfile"</paragraph>
239</tablecell>
240<tablecell>
241<paragraph role="tablecontent" id="par_id4186223" xml-lang="en-US" l10n="NEW">Always 1, for compatibility reasons</paragraph>
242</tablecell>
243</tablerow>
244<tablerow>
245<tablecell>
246<paragraph role="tablecontent" id="par_id5766472" xml-lang="en-US" l10n="NEW">"recalc"</paragraph>
247</tablecell>
248<tablecell>
249<paragraph role="tablecontent" id="par_id1491134" xml-lang="en-US" l10n="NEW">Current formula recalculation mode, either "Automatic" or "Manual" (localized into %PRODUCTNAME language)</paragraph>
250</tablecell>
251</tablerow>
252</table>
253
254<paragraph role="note" id="par_id1161534" xml-lang="en-US" l10n="NEW">Other spreadsheet applications may accept localized values for the <item type="literal">Type</item> parameter, but %PRODUCTNAME Calc will only accept the English values.</paragraph>
255<paragraph role="heading" id="hd_id5459456" xml-lang="en-US" level="3" l10n="NEW">Example</paragraph>
256<paragraph role="paragraph" id="par_id3994567" xml-lang="en-US" l10n="NEW">
257<item type="input">=INFO("release")</item> returns the product release number of the %PRODUCTNAME in use.<comment>Do not translate "release"</comment></paragraph>
258<paragraph role="paragraph" id="par_id2873622" xml-lang="en-US" l10n="NEW">
259<item type="input">=INFO(D5)</item> with cell <item type="literal">D5</item> containing a text string <item type="literal">system</item> returns the operation system type.<comment>Do not translate the hlp_literal system</comment></paragraph>
260</section>
261<section id="current">
262<bookmark xml-lang="en-US" branch="index" id="bm_id3155625"><bookmark_value>CURRENT function</bookmark_value>
263</bookmark>
264<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_AKTUELL" id="bm_id3145295" localize="false"/>
265<paragraph role="heading" id="hd_id3155625" xml-lang="en-US" level="2" l10n="U" oldref="30">CURRENT</paragraph>
266<paragraph role="paragraph" id="par_id3157975" xml-lang="en-US" l10n="CHG" oldref="31"><ahelp hid="HID_FUNC_AKTUELL">This function returns the result to date of evaluating the formula of which it is a part (in other words the result as far as that evaluation has got). Its main use is together with the STYLE() function to apply selected styles to a cell depending on the cell contents.</ahelp></paragraph>
267<paragraph role="heading" id="hd_id3148880" xml-lang="en-US" level="3" l10n="U" oldref="32">Syntax</paragraph>
268<paragraph role="code" id="par_id3150930" xml-lang="en-US" l10n="U" oldref="33">CURRENT()</paragraph>
269<paragraph role="heading" id="hd_id3145629" xml-lang="en-US" level="3" l10n="U" oldref="34">Example</paragraph>
270<paragraph role="paragraph" id="par_id5919064" xml-lang="en-US" l10n="NEW">
271<item type="input">=1+2+CURRENT()</item>
272</paragraph>
273<paragraph role="paragraph" id="par_id8751792" xml-lang="en-US" l10n="NEW">The example returns 6. The formula is calculated from left to right as: 1 + 2 equals 3, giving the result to date when CURRENT() is encountered; CURRENT() therefore yields 3, which is added to the original 3 to give 6.</paragraph>
274<paragraph role="paragraph" id="par_id5863826" xml-lang="en-US" l10n="NEW">
275<item type="input">=A2+B2+STYLE(IF(CURRENT()&gt;10;”Red”;”Default”))</item>
276</paragraph>
277<paragraph role="paragraph" id="par_id7463911" xml-lang="en-US" l10n="NEW">The example returns A2 + B2 (STYLE returns 0 here). If this sum is greater than 10, the style Red is applied to the cell. See the <emph>STYLE</emph> function for more explanation.</paragraph>
278<paragraph role="paragraph" id="par_id7318643" xml-lang="en-US" l10n="NEW">
279<item type="input">="choo"&amp;CURRENT()</item>
280</paragraph>
281<paragraph role="paragraph" id="par_id6019165" xml-lang="en-US" l10n="NEW">The example returns choochoo.</paragraph>
282</section>
283<section id="formula">
284<bookmark xml-lang="en-US" branch="index" id="bm_id3150688"><bookmark_value>FORMULA function</bookmark_value>
285<bookmark_value>formula cells;displaying formulas in other cells</bookmark_value>
286<bookmark_value>displaying;formulas at any position</bookmark_value>
287</bookmark><comment>mw added "formula cells;" and "displaying;"</comment>
288<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FORMEL" id="bm_id3155373" localize="false"/>
289<paragraph role="heading" id="hd_id3150688" xml-lang="en-US" level="2" l10n="U" oldref="147">FORMULA</paragraph>
290<paragraph role="paragraph" id="par_id3158417" xml-lang="en-US" l10n="CHG" oldref="148"><ahelp hid="HID_FUNC_FORMEL">Displays the formula of a formula cell as a text string.</ahelp></paragraph>
291<paragraph role="heading" id="hd_id3154954" xml-lang="en-US" level="3" l10n="U" oldref="149">Syntax</paragraph>
292<paragraph role="code" id="par_id3147535" xml-lang="en-US" l10n="CHG" oldref="150">FORMULA(Reference)</paragraph>
293<paragraph role="paragraph" id="par_id3014313" xml-lang="en-US" l10n="NEW">
294<emph>Reference</emph> is a reference to a cell containing a formula.</paragraph>
295<paragraph role="paragraph" id="par_id8857081" xml-lang="en-US" l10n="NEW">An invalid reference or a reference to a cell with no formula results in the error value #N/A.</paragraph>
296<paragraph role="heading" id="hd_id3152820" xml-lang="en-US" level="3" l10n="U" oldref="151">Example</paragraph>
297<paragraph role="paragraph" id="par_id3153179" xml-lang="en-US" l10n="CHG" oldref="152">If cell A8 contains the formula <item type="input">=SUM(1;2;3)</item> then</paragraph>
298<paragraph role="paragraph" id="par_id3153923" xml-lang="en-US" l10n="CHG" oldref="153">
299<item type="input">=FORMULA(A8)</item> returns the text =SUM(1;2;3).</paragraph>
300</section>
301<section id="isref">
302<bookmark xml-lang="en-US" branch="index" id="bm_id3155409"><bookmark_value>ISREF function</bookmark_value>
303<bookmark_value>references;testing cell contents</bookmark_value>
304<bookmark_value>cell contents;testing for references</bookmark_value>
305</bookmark><comment>mw added "references;" and "cell contents;"</comment>
306<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTBEZUG" id="bm_id3149774" localize="false"/>
307<paragraph role="heading" id="hd_id3155409" xml-lang="en-US" level="2" l10n="U" oldref="37">ISREF</paragraph>
308<paragraph role="paragraph" id="par_id3153723" xml-lang="en-US" l10n="CHG" oldref="38"><ahelp hid="HID_FUNC_ISTBEZUG">Tests if the argument is a reference.</ahelp> Returns TRUE if the argument is a reference, returns FALSE otherwise. When given a reference this function does not examine the value being referenced.<comment>i82565</comment></paragraph>
309<embed href="text/shared/00/00000001.xhp#wahr"/>
310<paragraph role="heading" id="hd_id3147175" xml-lang="en-US" level="3" l10n="U" oldref="39">Syntax</paragraph>
311<paragraph role="code" id="par_id3149821" xml-lang="en-US" l10n="U" oldref="40">ISREF(Value)</paragraph>
312<paragraph role="paragraph" id="par_id3146152" xml-lang="en-US" l10n="U" oldref="41">
313<emph>Value</emph> is the value to be tested, to determine whether it is a reference.</paragraph>
314<paragraph role="heading" id="hd_id3083448" xml-lang="en-US" level="3" l10n="U" oldref="42">Example</paragraph>
315<paragraph role="paragraph" id="par_id3154317" xml-lang="en-US" l10n="CHG" oldref="43">
316<item type="input">=ISREF(C5)</item> returns the result TRUE because C5 is a valid reference.</paragraph>
317<paragraph role="paragraph" id="par_id9728072" xml-lang="en-US" l10n="CHG">
318<item type="input">=ISREF("abcdef")</item> returns always FALSE because a text can never be a reference.</paragraph>
319<paragraph role="paragraph" id="par_id2131544" xml-lang="en-US" l10n="NEW">
320<item type="input">=ISREF(4)</item> returns FALSE.</paragraph>
321<paragraph role="paragraph" id="par_id4295480" xml-lang="en-US" l10n="NEW">
322<item type="input">=ISREF(INDIRECT("A6"))</item> returns TRUE, because INDIRECT is a function that returns a reference.</paragraph>
323<paragraph role="paragraph" id="par_id3626819" xml-lang="en-US" l10n="NEW">
324<item type="input">=ISREF(ADDRESS(1; 1; 2;"Sheet2"))</item> returns FALSE, because ADDRESS is a function that returns a text, although it looks like a reference.</paragraph>
325</section>
326<section id="iserr">
327<bookmark xml-lang="en-US" branch="index" id="bm_id3154812"><bookmark_value>ISERR function</bookmark_value>
328<bookmark_value>error codes;controlling</bookmark_value>
329</bookmark><comment>mw added "error codes,"</comment>
330<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTFEHL" id="bm_id3145081" localize="false"/>
331<paragraph role="heading" id="hd_id3154812" xml-lang="en-US" level="2" l10n="U" oldref="45">ISERR</paragraph>
332<paragraph role="paragraph" id="par_id3149282" xml-lang="en-US" l10n="CHG" oldref="46"><ahelp hid="HID_FUNC_ISTFEHL">Tests for error conditions, except the #N/A error value, and returns TRUE or FALSE.</ahelp></paragraph>
333<embed href="text/shared/00/00000001.xhp#wahr"/>
334<paragraph role="heading" id="hd_id3149450" xml-lang="en-US" level="3" l10n="U" oldref="47">Syntax</paragraph>
335<paragraph role="code" id="par_id3156312" xml-lang="en-US" l10n="U" oldref="48">ISERR(Value)</paragraph>
336<paragraph role="paragraph" id="par_id3146857" xml-lang="en-US" l10n="CHG" oldref="49">
337<emph>Value</emph> is any value or expression which is tested to see whether an error value other than #N/A is present.</paragraph>
338<paragraph role="heading" id="hd_id3153212" xml-lang="en-US" level="3" l10n="U" oldref="50">Example</paragraph>
339<paragraph role="paragraph" id="par_id3153276" xml-lang="en-US" l10n="CHG" oldref="51">
340<item type="input">=ISERR(C8)</item> where cell C8 contains <item type="input">=1/0</item> returns TRUE, because 1/0 is an error.</paragraph>
341<paragraph role="paragraph" id="par_id8456984" xml-lang="en-US" l10n="NEW">
342<item type="input">=ISERR(C9)</item> where cell C9 contains <item type="input">=NA()</item> returns FALSE, because ISERR() ignores the #N/A error.</paragraph>
343</section>
344<section id="iserror">
345<bookmark xml-lang="en-US" branch="index" id="bm_id3147081"><bookmark_value>ISERROR function</bookmark_value>
346<bookmark_value>recognizing;general errors</bookmark_value>
347</bookmark><comment>mw added "recognizing;"</comment>
348<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTFEHLER" id="bm_id3145206" localize="false"/>
349<paragraph role="heading" id="hd_id3147081" xml-lang="en-US" level="2" l10n="U" oldref="53">ISERROR</paragraph>
350<paragraph role="paragraph" id="par_id3156316" xml-lang="en-US" l10n="CHG" oldref="54"><ahelp hid="HID_FUNC_ISTFEHLER">Tests for error conditions, including the #N/A error value, and returns TRUE or FALSE.</ahelp></paragraph>
351<embed href="text/shared/00/00000001.xhp#wahr"/>
352<paragraph role="heading" id="hd_id3147569" xml-lang="en-US" level="3" l10n="U" oldref="55">Syntax</paragraph>
353<paragraph role="code" id="par_id3153155" xml-lang="en-US" l10n="U" oldref="56">ISERROR(Value)</paragraph>
354<paragraph role="paragraph" id="par_id3154047" xml-lang="en-US" l10n="CHG" oldref="57">
355<emph>Value</emph> is or refers to the value to be tested. ISERROR() returns TRUE if there is an error and FALSE if not.</paragraph>
356<paragraph role="heading" id="hd_id3155994" xml-lang="en-US" level="3" l10n="U" oldref="58">Example</paragraph>
357<paragraph role="paragraph" id="par_id3150256" xml-lang="en-US" l10n="CHG" oldref="59">
358<item type="input">=ISERROR(C8)</item> where cell C8 contains <item type="input">=1/0</item> returns TRUE, because 1/0 is an error.</paragraph>
359<paragraph role="paragraph" id="par_id1889095" xml-lang="en-US" l10n="NEW">
360<item type="input">=ISERROR(C9)</item> where cell C9 contains <item type="input">=NA()</item> returns TRUE.</paragraph>
361</section>
362<section id="isformula">
363<bookmark xml-lang="en-US" branch="index" id="bm_id3153618"><bookmark_value>ISFORMULA function</bookmark_value>
364<bookmark_value>recognizing formula cells</bookmark_value>
365<bookmark_value>formula cells;recognizing</bookmark_value>
366</bookmark><comment>mw inserted "recognizing..." and "formula cells;"</comment>
367<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTFORMEL" id="bm_id3154740" localize="false"/>
368<paragraph role="heading" id="hd_id3153618" xml-lang="en-US" level="2" l10n="U" oldref="61">ISFORMULA</paragraph>
369<paragraph role="paragraph" id="par_id3149138" xml-lang="en-US" l10n="U" oldref="62"><ahelp hid="HID_FUNC_ISTFORMEL">Returns TRUE if a cell is a formula cell.</ahelp></paragraph>
370<embed href="text/shared/00/00000001.xhp#wahr"/>
371<paragraph role="heading" id="hd_id3155100" xml-lang="en-US" level="3" l10n="U" oldref="63">Syntax</paragraph>
372<paragraph role="code" id="par_id3143230" xml-lang="en-US" l10n="U" oldref="64">ISFORMULA(Reference)</paragraph>
373<paragraph role="paragraph" id="par_id3150150" xml-lang="en-US" l10n="U" oldref="65">
374<emph>Reference</emph> indicates the reference to a cell in which a test will be performed to determine if it contains a formula.</paragraph>
375<paragraph role="heading" id="hd_id3147491" xml-lang="en-US" level="3" l10n="U" oldref="66">Example</paragraph>
376<paragraph role="paragraph" id="par_id3159182" xml-lang="en-US" l10n="CHG" oldref="67">
377<item type="input">=ISFORMULA(C4)</item> returns FALSE if the cell C4 contains the number <item type="input">5</item>.</paragraph>
378</section>
379<section id="iseven_add">
380<bookmark xml-lang="en-US" branch="index" id="bm_id3149760"><bookmark_value>ISEVEN_ADD function</bookmark_value>
381</bookmark>
382<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_ISEVEN" id="bm_id3146094" localize="false"/>
383<paragraph role="heading" id="hd_id3149760" xml-lang="en-US" level="2" oldref="229">ISEVEN_ADD</paragraph>
384<paragraph role="paragraph" id="par_id3147253" xml-lang="en-US" l10n="CHG" oldref="230"><ahelp hid="HID_AAI_FUNC_ISEVEN">Tests for even numbers. Returns 1 if the number divided by 2 returns a whole number.</ahelp></paragraph>
385<embed href="text/scalc/01/04060102.xhp#ADD_note"/>
386<paragraph role="heading" id="hd_id3152799" xml-lang="en-US" level="3" l10n="U" oldref="231">Syntax</paragraph>
387<paragraph role="code" id="par_id3149202" xml-lang="en-US" l10n="U" oldref="232">ISEVEN_ADD(Number)</paragraph>
388<paragraph role="paragraph" id="par_id3151168" xml-lang="en-US" l10n="CHG" oldref="233">
389<emph>Number</emph> is the number to be tested.</paragraph>
390<paragraph role="heading" id="hd_id3150115" xml-lang="en-US" level="3" l10n="U" oldref="234">Example</paragraph>
391<paragraph role="paragraph" id="par_id3153904" xml-lang="en-US" l10n="U" oldref="235">
392<item type="input">=ISEVEN_ADD(5)</item> returns 0.</paragraph>
393<paragraph role="paragraph" id="par_id6238308" xml-lang="en-US" l10n="NEW">
394<item type="input">=ISEVEN_ADD(A1)</item> returns 1 if cell A1 contains the number <item type="input">2</item>.</paragraph>
395</section>
396<section id="isnontext">
397<bookmark xml-lang="en-US" branch="index" id="bm_id3154692"><bookmark_value>ISNONTEXT function</bookmark_value>
398<bookmark_value>cell contents;no text</bookmark_value>
399</bookmark><comment>mw added "cell contents;"</comment>
400<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTKTEXT" id="bm_id3159342" localize="false"/>
401<paragraph role="heading" id="hd_id3154692" xml-lang="en-US" level="2" l10n="U" oldref="68">ISNONTEXT</paragraph>
402<paragraph role="paragraph" id="par_id3155330" xml-lang="en-US" l10n="U" oldref="69"><ahelp hid="HID_FUNC_ISTKTEXT">Tests if the cell contents are text or numbers, and returns FALSE if the contents are text.</ahelp></paragraph>
403<paragraph role="paragraph" id="par_id5719779" xml-lang="en-US" l10n="NEW">If an error occurs, the function returns TRUE.</paragraph>
404<paragraph role="heading" id="hd_id3154931" xml-lang="en-US" level="3" l10n="U" oldref="70">Syntax</paragraph>
405<paragraph role="code" id="par_id3148829" xml-lang="en-US" l10n="U" oldref="71">ISNONTEXT(Value)</paragraph>
406<paragraph role="paragraph" id="par_id3146992" xml-lang="en-US" l10n="U" oldref="72">
407<emph>Value</emph> is any value or expression where a test is performed to determine whether it is a text or numbers or a Boolean value.</paragraph>
408<paragraph role="heading" id="hd_id3150525" xml-lang="en-US" level="3" l10n="U" oldref="73">Example</paragraph>
409<paragraph role="paragraph" id="par_id3149906" xml-lang="en-US" l10n="CHG" oldref="74">
410<item type="input">=ISNONTEXT(D2)</item> returns FALSE if cell D2 contains the text <item type="input">abcdef</item>.</paragraph>
411<paragraph role="paragraph" id="par_id3150777" xml-lang="en-US" l10n="CHG" oldref="75">
412<item type="input">=ISNONTEXT(D9)</item> returns TRUE if cell D9 contains the number <item type="input">8</item>.</paragraph>
413</section>
414<section id="isblank">
415<bookmark xml-lang="en-US" branch="index" id="bm_id3159148"><bookmark_value>ISBLANK function</bookmark_value>
416<bookmark_value>blank cell contents</bookmark_value>
417<bookmark_value>empty cells; recognizing</bookmark_value>
418</bookmark><comment>mw added "blank..." and "empty cells;"</comment>
419<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTLEER" id="bm_id3148940" localize="false"/>
420<paragraph role="heading" id="hd_id3159148" xml-lang="en-US" level="2" l10n="U" oldref="77">ISBLANK</paragraph>
421<paragraph role="paragraph" id="par_id3148800" xml-lang="en-US" l10n="U" oldref="78"><ahelp hid="HID_FUNC_ISTLEER">Returns TRUE if the reference to a cell is blank.</ahelp> This function is used to determine if the content of a cell is empty. A cell with a formula inside is not empty. </paragraph>
422<embed href="text/shared/00/00000001.xhp#wahr"/>
423<paragraph role="heading" id="hd_id3159162" xml-lang="en-US" level="3" l10n="U" oldref="79">Syntax</paragraph>
424<paragraph role="code" id="par_id3158406" xml-lang="en-US" l10n="U" oldref="80">ISBLANK(Value)</paragraph>
425<paragraph role="paragraph" id="par_id3154212" xml-lang="en-US" l10n="U" oldref="81">
426<emph>Value</emph> is the content to be tested.</paragraph>
427<paragraph role="heading" id="hd_id3147508" xml-lang="en-US" level="3" l10n="U" oldref="82">Example</paragraph>
428<paragraph role="paragraph" id="par_id3147234" xml-lang="en-US" l10n="U" oldref="83">
429<item type="input">=ISBLANK(D2)</item> returns FALSE as a result.</paragraph>
430</section>
431<section id="islogical">
432<bookmark xml-lang="en-US" branch="index" id="bm_id3155356"><bookmark_value>ISLOGICAL function</bookmark_value>
433<bookmark_value>number formats;logical</bookmark_value>
434<bookmark_value>logical number formats</bookmark_value>
435</bookmark><comment>mw added "number formats;" and "logical..."</comment>
436<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTLOG" id="bm_id3158424" localize="false"/>
437<paragraph role="heading" id="hd_id3155356" xml-lang="en-US" level="2" l10n="U" oldref="85">ISLOGICAL</paragraph>
438<paragraph role="paragraph" id="par_id3148926" xml-lang="en-US" l10n="CHG" oldref="86"><ahelp hid="HID_FUNC_ISTLOG">Tests for a logical value (TRUE or FALSE).</ahelp></paragraph>
439<paragraph role="paragraph" id="par_id3541062" xml-lang="en-US" l10n="NEW">If an error occurs, the function returns FALSE.</paragraph>
440<paragraph role="heading" id="hd_id3149162" xml-lang="en-US" level="3" l10n="U" oldref="87">Syntax</paragraph>
441<paragraph role="code" id="par_id3148918" xml-lang="en-US" l10n="U" oldref="88">ISLOGICAL(Value)</paragraph>
442<paragraph role="paragraph" id="par_id3146946" xml-lang="en-US" l10n="CHG" oldref="89">Returns TRUE if <emph>Value</emph> is a logical value (TRUE or FALSE), and returns FALSE otherwise.</paragraph>
443<paragraph role="heading" id="hd_id3150709" xml-lang="en-US" level="3" l10n="U" oldref="90">Example</paragraph>
444<paragraph role="paragraph" id="par_id3166442" xml-lang="en-US" l10n="CHG" oldref="91">
445<item type="input">=ISLOGICAL(99)</item> returns FALSE, because 99 is a number, not a logical value.</paragraph>
446<paragraph role="paragraph" id="par_id3556016" xml-lang="en-US" l10n="NEW">
447<item type="input">=ISLOGICAL(ISNA(D4))</item> returns TRUE whatever the contents of cell D4, because ISNA() returns a logical value.</paragraph>
448</section>
449<section id="isna">
450<bookmark xml-lang="en-US" branch="index" id="bm_id3153685"><bookmark_value>ISNA function</bookmark_value>
451<bookmark_value>#N/A error;recognizing</bookmark_value>
452</bookmark><comment>mw added "#N/A ..."</comment>
453<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTNV" id="bm_id3159273" localize="false"/>
454<paragraph role="heading" id="hd_id3153685" xml-lang="en-US" level="2" l10n="U" oldref="93">ISNA</paragraph>
455<paragraph role="paragraph" id="par_id3149105" xml-lang="en-US" l10n="U" oldref="94"><ahelp hid="HID_FUNC_ISTNV">Returns TRUE if a cell contains the #N/A (value not available) error value.</ahelp></paragraph>
456<paragraph role="paragraph" id="par_id6018860" xml-lang="en-US" l10n="NEW">If an error occurs, the function returns FALSE.</paragraph>
457<paragraph role="heading" id="hd_id3152947" xml-lang="en-US" level="3" l10n="U" oldref="95">Syntax</paragraph>
458<paragraph role="code" id="par_id3153748" xml-lang="en-US" l10n="U" oldref="96">ISNA(Value)</paragraph>
459<paragraph role="paragraph" id="par_id3152884" xml-lang="en-US" l10n="U" oldref="97">
460<emph>Value</emph> is the value or expression to be tested.</paragraph>
461<paragraph role="heading" id="hd_id3149964" xml-lang="en-US" level="3" l10n="U" oldref="98">Example</paragraph>
462<paragraph role="paragraph" id="par_id3154852" xml-lang="en-US" l10n="U" oldref="99">
463<item type="input">=ISNA(D3)</item> returns FALSE as a result.</paragraph>
464</section>
465<section id="istext">
466<bookmark xml-lang="en-US" branch="index" id="bm_id3149426"><bookmark_value>ISTEXT function</bookmark_value>
467<bookmark_value>cell contents;text</bookmark_value>
468</bookmark>
469<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTTEXT" id="bm_id3148468" localize="false"/>
470<paragraph role="heading" id="hd_id3149426" xml-lang="en-US" level="2" l10n="U" oldref="101">ISTEXT</paragraph>
471<paragraph role="paragraph" id="par_id3145368" xml-lang="en-US" l10n="U" oldref="102"><ahelp hid="HID_FUNC_ISTTEXT">Returns TRUE if the cell contents refer to text.</ahelp></paragraph>
472<paragraph role="paragraph" id="par_id6779686" xml-lang="en-US" l10n="NEW">If an error occurs, the function returns FALSE.</paragraph>
473<paragraph role="heading" id="hd_id3154332" xml-lang="en-US" level="3" l10n="U" oldref="103">Syntax</paragraph>
474<paragraph role="code" id="par_id3148649" xml-lang="en-US" l10n="U" oldref="104">ISTEXT(Value)</paragraph>
475<paragraph role="paragraph" id="par_id3150417" xml-lang="en-US" l10n="U" oldref="105">
476<emph>Value</emph> is a value, number, Boolean value, or an error value to be tested.</paragraph>
477<paragraph role="heading" id="hd_id3149239" xml-lang="en-US" level="3" l10n="U" oldref="106">Example</paragraph>
478<paragraph role="paragraph" id="par_id3144756" xml-lang="en-US" l10n="CHG" oldref="107">
479<item type="input">=ISTEXT(D9)</item> returns TRUE if cell D9 contains the text <item type="input">abcdef</item>.</paragraph>
480<paragraph role="paragraph" id="par_id3148416" xml-lang="en-US" l10n="CHG" oldref="108">
481<item type="input">=ISTEXT(C3)</item> returns FALSE if cell C3 contains the number <item type="input">3</item>.</paragraph>
482</section>
483<section id="isodd_add">
484<bookmark xml-lang="en-US" branch="index" id="bm_id3153939"><bookmark_value>ISODD_ADD function</bookmark_value>
485</bookmark>
486<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_ISODD" id="bm_id3149927" localize="false"/>
487<paragraph role="heading" id="hd_id3153939" xml-lang="en-US" level="2" oldref="236">ISODD_ADD</paragraph>
488<paragraph role="paragraph" id="par_id3153538" xml-lang="en-US" l10n="U" oldref="237"><ahelp hid="HID_AAI_FUNC_ISODD">Returns TRUE (1) if the number does not return a whole number when divided by 2.</ahelp></paragraph>
489<embed href="text/scalc/01/04060102.xhp#ADD_note"/>
490<paragraph role="heading" id="hd_id3145601" xml-lang="en-US" level="3" l10n="U" oldref="238">Syntax</paragraph>
491<paragraph role="code" id="par_id3149485" xml-lang="en-US" l10n="U" oldref="239">ISODD_ADD(Number)</paragraph>
492<paragraph role="paragraph" id="par_id3153315" xml-lang="en-US" l10n="U" oldref="240">
493<emph>Number</emph> is the number to be tested.</paragraph>
494<paragraph role="heading" id="hd_id3143274" xml-lang="en-US" level="3" l10n="U" oldref="241">Example</paragraph>
495<paragraph role="paragraph" id="par_id3154793" xml-lang="en-US" l10n="U" oldref="242">
496<item type="input">=ISODD_ADD(5)</item> returns 1.</paragraph>
497</section>
498<section id="isnumber">
499<bookmark xml-lang="en-US" branch="index" id="bm_id3148688"><bookmark_value>ISNUMBER function</bookmark_value>
500<bookmark_value>cell contents;numbers</bookmark_value>
501</bookmark><comment>mw added "cell contents;"</comment>
502<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTZAHL" id="bm_id3149587" localize="false"/>
503<paragraph role="heading" id="hd_id3148688" xml-lang="en-US" level="2" l10n="U" oldref="110">ISNUMBER</paragraph>
504<paragraph role="paragraph" id="par_id3154618" xml-lang="en-US" l10n="U" oldref="111"><ahelp hid="HID_FUNC_ISTZAHL">Returns TRUE if the value refers to a number.</ahelp></paragraph>
505<embed href="text/shared/00/00000001.xhp#wahr"/>
506<paragraph role="heading" id="hd_id3152769" xml-lang="en-US" level="3" l10n="U" oldref="112">Syntax</paragraph>
507<paragraph role="code" id="par_id3150595" xml-lang="en-US" l10n="U" oldref="113">ISNUMBER(Value)</paragraph>
508<paragraph role="paragraph" id="par_id3150351" xml-lang="en-US" l10n="U" oldref="114">
509<emph>Value</emph> is any expression to be tested to determine whether it is a number or text.</paragraph>
510<paragraph role="heading" id="hd_id3146793" xml-lang="en-US" level="3" l10n="U" oldref="115">Example</paragraph>
511<paragraph role="paragraph" id="par_id3155614" xml-lang="en-US" l10n="CHG" oldref="116">
512<item type="input">=ISNUMBER(C3)</item> returns TRUE if the cell C3 contains the number <item type="input">4</item>.</paragraph>
513<paragraph role="paragraph" id="par_id3154417" xml-lang="en-US" l10n="CHG" oldref="117">
514<item type="input">=ISNUMBER(C2)</item> returns FALSE if the cell C2 contains the text <item type="input">abcdef</item>.</paragraph>
515</section>
516<section id="n">
517<bookmark xml-lang="en-US" branch="index" id="bm_id3153694"><bookmark_value>N function</bookmark_value>
518</bookmark>
519<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_N" id="bm_id3153786" localize="false"/>
520<paragraph role="heading" id="hd_id3153694" xml-lang="en-US" level="2" l10n="U" oldref="119">N</paragraph>
521<paragraph role="paragraph" id="par_id3150405" xml-lang="en-US" l10n="CHG" oldref="120"><ahelp hid="HID_FUNC_N">Returns the numeric value of the given parameter. Returns 0 if parameter is text, FALSE or #NA.</ahelp></paragraph>
522<paragraph role="paragraph" id="par_id9115573" xml-lang="en-US" l10n="NEW">If an error occurs, other than #NA, the function returns the error value.</paragraph>
523<paragraph role="heading" id="hd_id3145774" xml-lang="en-US" level="3" l10n="U" oldref="121">Syntax</paragraph>
524<paragraph role="code" id="par_id3153883" xml-lang="en-US" l10n="U" oldref="122">N(Value)</paragraph>
525<paragraph role="paragraph" id="par_id3151101" xml-lang="en-US" l10n="CHG" oldref="123">
526<emph>Value</emph> is the parameter to be converted into a number. N() returns the numeric value if it can. It returns the logical values TRUE and FALSE as 1 and 0 respectively. It returns text and errors as 0.</paragraph>
527<paragraph role="heading" id="hd_id3147097" xml-lang="en-US" level="3" l10n="U" oldref="124">Example</paragraph>
528<paragraph role="paragraph" id="par_id3154117" xml-lang="en-US" l10n="CHG" oldref="125">
529<item type="input">=N(123)</item> returns 123</paragraph>
530<paragraph role="paragraph" id="par_id2337717" xml-lang="en-US" l10n="NEW">
531<item type="input">=N(TRUE)</item> returns 1</paragraph>
532<paragraph role="paragraph" id="par_id3153781" xml-lang="en-US" l10n="U" oldref="126">
533<item type="input">=N(FALSE)</item> returns 0</paragraph>
534<paragraph role="paragraph" id="par_id3154670" xml-lang="en-US" l10n="U" oldref="243">
535<item type="input">=N("abc")</item> returns 0</paragraph>
536<paragraph role="paragraph" id="par_id3519089" xml-lang="en-US" l10n="NEW">=N(1/0) returns #DIV/0!</paragraph>
537</section>
538<section id="na">
539<bookmark xml-lang="en-US" branch="index" id="bm_id3156275"><bookmark_value>NA function</bookmark_value>
540<bookmark_value>#N/A error;assigning to a cell</bookmark_value>
541</bookmark><comment>mw added "#N/A error;"</comment>
542<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NV" id="bm_id3154569" localize="false"/>
543<paragraph role="heading" id="hd_id3156275" xml-lang="en-US" level="2" l10n="U" oldref="129">NA</paragraph>
544<paragraph role="paragraph" id="par_id3156161" xml-lang="en-US" l10n="U" oldref="130"><ahelp hid="HID_FUNC_NV">Returns the error value #N/A.</ahelp></paragraph>
545<paragraph role="heading" id="hd_id3147532" xml-lang="en-US" level="3" l10n="U" oldref="131">Syntax</paragraph>
546<paragraph role="code" id="par_id3149563" xml-lang="en-US" l10n="U" oldref="132">NA()</paragraph>
547<paragraph role="heading" id="hd_id3155128" xml-lang="en-US" level="3" l10n="U" oldref="133">Example</paragraph>
548<paragraph role="paragraph" id="par_id3154481" xml-lang="en-US" l10n="U" oldref="134">
549<item type="input">=NA()</item> converts the contents of the cell into #N/A.</paragraph>
550</section>
551<section id="type">
552<bookmark xml-lang="en-US" branch="index" id="bm_id3151255"><bookmark_value>TYPE function</bookmark_value>
553</bookmark>
554<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TYP" id="bm_id3146127" localize="false"/>
555<paragraph role="heading" id="hd_id3151255" xml-lang="en-US" level="2" l10n="U" oldref="136">TYPE</paragraph>
556<paragraph role="paragraph" id="par_id3155900" xml-lang="en-US" l10n="U" oldref="137"><ahelp hid="HID_FUNC_TYP">Returns the type of value, where 1 = number, 2 = text, 4 = Boolean value, 8 = formula, 16 = error value, 64 = array.</ahelp></paragraph>
557<embed href="text/shared/00/00000001.xhp#wahr"/>
558<paragraph role="heading" id="hd_id3149992" xml-lang="en-US" level="3" l10n="U" oldref="138">Syntax</paragraph>
559<paragraph role="code" id="par_id3148400" xml-lang="en-US" l10n="U" oldref="139">TYPE(Value)</paragraph>
560<paragraph role="paragraph" id="par_id3150830" xml-lang="en-US" l10n="U" oldref="140">
561<emph>Value</emph> is a specific value for which the data type is determined.</paragraph>
562<paragraph role="heading" id="hd_id3154363" xml-lang="en-US" level="3" l10n="U" oldref="141">Example (see example table above)</paragraph>
563<paragraph role="paragraph" id="par_id3153357" xml-lang="en-US" l10n="U" oldref="142">
564<item type="input">=TYPE(C2)</item> returns 2 as a result.</paragraph>
565<paragraph role="paragraph" id="par_id3148980" xml-lang="en-US" l10n="U" oldref="143">
566<item type="input">=TYPE(D9)</item> returns 1 as a result.</paragraph>
567</section>
568<section id="cell">
569<bookmark xml-lang="en-US" branch="index" id="bm_id3155509"><bookmark_value>CELL function</bookmark_value>
570<bookmark_value>cell information</bookmark_value>
571<bookmark_value>information on cells</bookmark_value>
572</bookmark><comment>mw added two entries</comment>
573<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZELLE" id="bm_id3159412" localize="false"/>
574<paragraph role="heading" id="hd_id3155509" xml-lang="en-US" level="2" l10n="U" oldref="154">CELL</paragraph>
575<paragraph role="paragraph" id="par_id3153196" xml-lang="en-US" l10n="U" oldref="155"><ahelp hid="HID_FUNC_ZELLE">Returns information on address, formatting or contents of a cell.</ahelp></paragraph>
576<paragraph role="heading" id="hd_id3149323" xml-lang="en-US" level="3" l10n="U" oldref="156">Syntax</paragraph>
577<paragraph role="code" id="par_id3147355" xml-lang="en-US" l10n="U" oldref="157">CELL("InfoType"; Reference)</paragraph>
578<paragraph role="paragraph" id="par_id3154716" xml-lang="en-US" l10n="U" oldref="158">
579<emph>InfoType</emph> is the character string that specifies the type of information. The character string is always in English. Upper or lower case is optional.</paragraph>
580<table id="tbl_id3152470">
581<tablerow>
582<tablecell>
583<paragraph role="tablehead" id="par_id3150636" xml-lang="en-US" l10n="U" oldref="165">InfoType</paragraph>
584</tablecell>
585<tablecell>
586<paragraph role="tablehead" id="par_id3149344" xml-lang="en-US" l10n="U" oldref="166">Meaning</paragraph>
587</tablecell>
588</tablerow>
589<tablerow>
590<tablecell>
591<paragraph role="code" id="par_id3153266" xml-lang="en-US" l10n="U" oldref="167">COL</paragraph>
592</tablecell>
593<tablecell>
594<paragraph role="tablecontent" id="par_id3156204" xml-lang="en-US" l10n="U" oldref="168">Returns the number of the referenced column.</paragraph>
595<paragraph role="tablecontent" id="par_id3150094" xml-lang="en-US" l10n="U" oldref="162">
596<item type="input">=CELL("COL";D2)</item> returns 4.</paragraph>
597</tablecell>
598</tablerow>
599<tablerow>
600<tablecell>
601<paragraph role="code" id="par_id3151276" xml-lang="en-US" l10n="U" oldref="169">ROW</paragraph>
602</tablecell>
603<tablecell>
604<paragraph role="tablecontent" id="par_id3147583" xml-lang="en-US" l10n="U" oldref="170">Returns the number of the referenced row.</paragraph>
605<paragraph role="tablecontent" id="par_id3151222" xml-lang="en-US" l10n="U" oldref="163">
606<item type="input">=CELL("ROW";D2)</item> returns 2.</paragraph>
607</tablecell>
608</tablerow>
609<tablerow>
610<tablecell>
611<paragraph role="code" id="par_id3159217" xml-lang="en-US" l10n="U" oldref="171">SHEET</paragraph>
612</tablecell>
613<tablecell>
614<paragraph role="tablecontent" id="par_id3151201" xml-lang="en-US" l10n="U" oldref="172">Returns the number of the referenced sheet.</paragraph>
615<paragraph role="tablecontent" id="par_id3149169" xml-lang="en-US" l10n="U" oldref="164">
616<item type="input">=CELL("Sheet";Sheet3.D2)</item> returns 3.</paragraph>
617</tablecell>
618</tablerow>
619<tablerow>
620<tablecell>
621<paragraph role="code" id="par_id3149431" xml-lang="en-US" l10n="U" oldref="173">ADDRESS</paragraph>
622</tablecell>
623<tablecell>
624<paragraph role="tablecontent" id="par_id3156054" xml-lang="en-US" l10n="U" oldref="174">Returns the absolute address of the referenced cell.</paragraph>
625<paragraph role="tablecontent" id="par_id3154136" xml-lang="en-US" l10n="U" oldref="175">
626<item type="input">=CELL("ADDRESS";D2)</item> returns $D$2.</paragraph>
627<paragraph role="tablecontent" id="par_id3159198" xml-lang="en-US" l10n="U" oldref="176">
628<item type="input">=CELL("ADDRESS";Sheet3.D2)</item> returns $Sheet3.$D$2.</paragraph>
629<paragraph role="tablecontent" id="par_id3150245" xml-lang="en-US" l10n="U" oldref="177">
630<item type="input">=CELL("ADDRESS";'X:\dr\test.ods'#$Sheet1.D2)</item> returns 'file:///X:/dr/test.ods'#$Sheet1.$D$2.</paragraph>
631</tablecell>
632</tablerow>
633<tablerow>
634<tablecell>
635<paragraph role="code" id="par_id3146811" xml-lang="en-US" l10n="U" oldref="178">FILENAME</paragraph>
636</tablecell>
637<tablecell>
638<paragraph role="tablecontent" id="par_id3151328" xml-lang="en-US" l10n="U" oldref="179">Returns the file name and the sheet number of the referenced cell.</paragraph>
639<paragraph role="tablecontent" id="par_id3148896" xml-lang="en-US" l10n="U" oldref="180">
640<item type="input">=CELL("FILENAME";D2)</item> returns 'file:///X:/dr/own.ods'#$Sheet1, if the formula in the current document X:\dr\own.ods is located in Sheet1.</paragraph>
641<paragraph role="tablecontent" id="par_id3155144" xml-lang="en-US" l10n="U" oldref="181">
642<item type="input">=CELL("FILENAME";'X:\dr\test.ods'#$Sheet1.D2)</item> returns 'file:///X:/dr/test.ods'#$Sheet1.</paragraph>
643</tablecell>
644</tablerow>
645<tablerow>
646<tablecell>
647<paragraph role="code" id="par_id3151381" xml-lang="en-US" l10n="U" oldref="182">COORD</paragraph>
648</tablecell>
649<tablecell>
650<paragraph role="tablecontent" id="par_id3151004" xml-lang="en-US" l10n="U" oldref="183">Returns the complete cell address in Lotus(TM) notation.</paragraph>
651<paragraph role="tablecontent" id="par_id3159104" xml-lang="en-US" l10n="U" oldref="184">
652<item type="input">=CELL("COORD"; D2)</item> returns $A:$D$2.</paragraph>
653<paragraph role="tablecontent" id="par_id3163720" xml-lang="en-US" l10n="U" oldref="185">
654<item type="input">=CELL("COORD"; Sheet3.D2)</item> returns $C:$D$2.</paragraph>
655</tablecell>
656</tablerow>
657<tablerow>
658<tablecell>
659<paragraph role="code" id="par_id3155910" xml-lang="en-US" l10n="U" oldref="186">CONTENTS</paragraph>
660</tablecell>
661<tablecell>
662<paragraph role="tablecontent" id="par_id3156041" xml-lang="en-US" l10n="U" oldref="187">Returns the contents of the referenced cell, without any formatting.</paragraph>
663</tablecell>
664</tablerow>
665<tablerow>
666<tablecell>
667<paragraph role="code" id="par_id3151069" xml-lang="en-US" l10n="U" oldref="188">TYPE</paragraph>
668</tablecell>
669<tablecell>
670<paragraph role="tablecontent" id="par_id3155344" xml-lang="en-US" l10n="U" oldref="189">Returns the type of cell contents.</paragraph>
671<paragraph role="tablecontent" id="par_id3145217" xml-lang="en-US" l10n="U" oldref="190">b = blank. empty cell</paragraph>
672<paragraph role="tablecontent" id="par_id3155176" xml-lang="en-US" l10n="U" oldref="191">l = label. Text, result of a formula as text</paragraph>
673<paragraph role="tablecontent" id="par_id3147280" xml-lang="en-US" l10n="U" oldref="192">v = value. Value, result of a formula as a number</paragraph>
674</tablecell>
675</tablerow>
676<tablerow>
677<tablecell>
678<paragraph role="code" id="par_id3156348" xml-lang="en-US" l10n="U" oldref="193">WIDTH</paragraph>
679</tablecell>
680<tablecell>
681<paragraph role="tablecontent" id="par_id3154920" xml-lang="en-US" l10n="U" oldref="194">Returns the width of the referenced column. The unit is the number of zeros (0) that fit into the column in the default text and the default size.</paragraph>
682</tablecell>
683</tablerow>
684<tablerow>
685<tablecell>
686<paragraph role="code" id="par_id3152355" xml-lang="en-US" l10n="U" oldref="195">PREFIX</paragraph>
687</tablecell>
688<tablecell>
689<paragraph role="tablecontent" id="par_id3154230" xml-lang="en-US" l10n="U" oldref="196">Returns the alignment of the referenced cell.</paragraph>
690<paragraph role="tablecontent" id="par_id3155946" xml-lang="en-US" l10n="U" oldref="197">' = align left or left-justified</paragraph>
691<paragraph role="tablecontent" id="par_id3147220" xml-lang="en-US" l10n="U" oldref="198">" = align right</paragraph>
692<paragraph role="tablecontent" id="par_id3149038" xml-lang="en-US" l10n="U" oldref="199">^ = centered</paragraph>
693<paragraph role="tablecontent" id="par_id3153129" xml-lang="en-US" l10n="U" oldref="200">\ = repeating (currently inactive)</paragraph>
694</tablecell>
695</tablerow>
696<tablerow>
697<tablecell>
698<paragraph role="code" id="par_id3154406" xml-lang="en-US" l10n="U" oldref="201">PROTECT</paragraph>
699</tablecell>
700<tablecell>
701<paragraph role="tablecontent" id="par_id3145127" xml-lang="en-US" l10n="U" oldref="202">Returns the status of the cell protection for the cell.</paragraph>
702<paragraph role="tablecontent" id="par_id3155794" xml-lang="en-US" l10n="U" oldref="203">1 = cell is protected</paragraph>
703<paragraph role="tablecontent" id="par_id3155072" xml-lang="en-US" l10n="U" oldref="204">0 = cell is not protected</paragraph>
704</tablecell>
705</tablerow>
706<tablerow>
707<tablecell>
708<paragraph role="code" id="par_id3156178" xml-lang="en-US" l10n="U" oldref="205">FORMAT</paragraph>
709</tablecell>
710<tablecell>
711<paragraph role="tablecontent" id="par_id3150220" xml-lang="en-US" l10n="U" oldref="206">Returns a character string that indicates the number format.</paragraph>
712<paragraph role="tablecontent" id="par_id3153824" xml-lang="en-US" l10n="U" oldref="207">, = number with thousands separator</paragraph>
713<paragraph role="tablecontent" id="par_id3153837" xml-lang="en-US" l10n="U" oldref="208">F = number without thousands separator</paragraph>
714<paragraph role="tablecontent" id="par_id3150318" xml-lang="en-US" l10n="U" oldref="209">C = currency format</paragraph>
715<paragraph role="tablecontent" id="par_id3153168" xml-lang="en-US" l10n="U" oldref="210">S = exponential representation, for example, 1.234+E56</paragraph>
716<paragraph role="tablecontent" id="par_id3153515" xml-lang="en-US" l10n="U" oldref="211">P = percentage</paragraph>
717<paragraph role="tablecontent" id="par_id3154375" xml-lang="en-US" l10n="U" oldref="212">In the above formats, the number of decimal places after the decimal separator is given as a number. Example: the number format #,##0.0 returns ,1 and the number format 00.000% returns P3</paragraph>
718<paragraph role="tablecontent" id="par_id3150575" xml-lang="en-US" l10n="U" oldref="213">D1 = MMM-D-YY, MM-D-YY and similar formats</paragraph>
719<paragraph role="tablecontent" id="par_id3150589" xml-lang="en-US" l10n="U" oldref="214">D2 = DD-MM</paragraph>
720<paragraph role="tablecontent" id="par_id3151034" xml-lang="en-US" l10n="U" oldref="215">D3 = MM-YY</paragraph>
721<paragraph role="tablecontent" id="par_id3156371" xml-lang="en-US" l10n="U" oldref="216">D4 = DD-MM-YYYY HH:MM:SS</paragraph>
722<paragraph role="tablecontent" id="par_id3157881" xml-lang="en-US" l10n="U" oldref="217">D5 = MM-DD</paragraph>
723<paragraph role="tablecontent" id="par_id3157894" xml-lang="en-US" l10n="U" oldref="218">D6 = HH:MM:SS AM/PM</paragraph>
724<paragraph role="tablecontent" id="par_id3154068" xml-lang="en-US" l10n="U" oldref="219">D7 = HH:MM AM/PM</paragraph>
725<paragraph role="tablecontent" id="par_id3150286" xml-lang="en-US" l10n="U" oldref="220">D8 = HH:MM:SS</paragraph>
726<paragraph role="tablecontent" id="par_id3145756" xml-lang="en-US" l10n="U" oldref="221">D9 = HH:MM</paragraph>
727<paragraph role="tablecontent" id="par_id3145768" xml-lang="en-US" l10n="U" oldref="222">G = All other formats</paragraph>
728<paragraph role="tablecontent" id="par_id3153375" xml-lang="en-US" l10n="U" oldref="223">- (Minus) at the end = negative numbers are formatted in color</paragraph>
729<paragraph role="tablecontent" id="par_id3155545" xml-lang="en-US" l10n="U" oldref="224">() (brackets) at the end = there is an opening bracket in the format code</paragraph>
730</tablecell>
731</tablerow>
732<tablerow>
733<tablecell>
734<paragraph role="code" id="par_id3154594" xml-lang="en-US" l10n="U" oldref="225">COLOR</paragraph>
735</tablecell>
736<tablecell>
737<paragraph role="tablecontent" id="par_id3152922" xml-lang="en-US" l10n="U" oldref="226">Returns 1, if negative values have been formatted in color, otherwise 0.</paragraph>
738</tablecell>
739</tablerow>
740<tablerow>
741<tablecell>
742<paragraph role="code" id="par_id3145563" xml-lang="en-US" l10n="U" oldref="227">PARENTHESES</paragraph>
743</tablecell>
744<tablecell>
745<paragraph role="tablecontent" id="par_id3156072" xml-lang="en-US" l10n="U" oldref="228">Returns 1 if the format code contains an opening bracket (, otherwise 0.</paragraph>
746</tablecell>
747</tablerow>
748</table>
749
750<paragraph role="paragraph" id="par_id3156090" xml-lang="en-US" l10n="U" oldref="159">
751<emph>Reference</emph> (list of options) is the position of the cell to be examined. If <emph>Reference</emph> is a range, the cell moves to the top left of the range. If <emph>Reference</emph> is missing, $[officename] Calc uses the position of the cell in which this formula is located. Microsoft Excel uses the reference of the cell in which the cursor is positioned.</paragraph>
752</section>
753</sort>
754<section id="relatedtopics">
755<embed href="text/scalc/01/04060100.xhp#drking"/>
756</section>
757</body>
758</helpdocument>
759