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