helpcontent2/source/text/scalc/01/04060104.xhp

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