1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 302dbb15cSAndrew Rist<!--*********************************************************** 4cdf0e10cSrcweir * 502dbb15cSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 602dbb15cSAndrew Rist * or more contributor license agreements. See the NOTICE file 702dbb15cSAndrew Rist * distributed with this work for additional information 802dbb15cSAndrew Rist * regarding copyright ownership. The ASF licenses this file 902dbb15cSAndrew Rist * to you under the Apache License, Version 2.0 (the 1002dbb15cSAndrew Rist * "License"); you may not use this file except in compliance 1102dbb15cSAndrew Rist * with the License. You may obtain a copy of the License at 12cdf0e10cSrcweir * 1302dbb15cSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 14cdf0e10cSrcweir * 1502dbb15cSAndrew Rist * Unless required by applicable law or agreed to in writing, 1602dbb15cSAndrew Rist * software distributed under the License is distributed on an 1702dbb15cSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 1802dbb15cSAndrew Rist * KIND, either express or implied. See the License for the 1902dbb15cSAndrew Rist * specific language governing permissions and limitations 2002dbb15cSAndrew Rist * under the License. 21cdf0e10cSrcweir * 2202dbb15cSAndrew Rist ***********************************************************--> 2302dbb15cSAndrew Rist 243de3c617Smseidel<helpdocument version="1.0"> 25cdf0e10cSrcweir<meta> 26cdf0e10cSrcweir<topic id="textscalc0104060104xml" indexer="include"> 27cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Information Functions</title> 28cdf0e10cSrcweir<filename>/text/scalc/01/04060104.xhp</filename> 29cdf0e10cSrcweir</topic> 30cdf0e10cSrcweir</meta> 31cdf0e10cSrcweir<body> 323de3c617Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3147247"> 333de3c617Smseidel<bookmark_value>information functions</bookmark_value> 34cdf0e10cSrcweir<bookmark_value>Function Wizard; information</bookmark_value> 35cdf0e10cSrcweir<bookmark_value>functions; information functions</bookmark_value> 36cdf0e10cSrcweir</bookmark> 374702cb60Smseidel<paragraph role="heading" id="hd_id3147247" xml-lang="en-US" level="1" l10n="U">Information Functions</paragraph> 384702cb60Smseidel<paragraph role="paragraph" id="par_id3147499" xml-lang="en-US" l10n="CHG"><variable id="informationtext">This category contains the <emph>Information</emph> functions. 39cdf0e10cSrcweir</variable></paragraph> 40cdf0e10cSrcweir<section id="howtoget"> 41cdf0e10cSrcweir<embed href="text/scalc/00/00000404.xhp#eikain"/> 42cdf0e10cSrcweir</section> 434702cb60Smseidel<paragraph role="paragraph" id="par_id3159128" xml-lang="en-US" l10n="U">The data in the following table serves as the basis for some of the examples in the function descriptions:</paragraph> 44cdf0e10cSrcweir<table id="tbl_id3157876"> 45cdf0e10cSrcweir<tablerow> 46cdf0e10cSrcweir<tablecell> 47cdf0e10cSrcweir</tablecell> 48cdf0e10cSrcweir<tablecell> 494702cb60Smseidel<paragraph role="tablehead" id="par_id3146885" xml-lang="en-US" l10n="U">C</paragraph> 50cdf0e10cSrcweir</tablecell> 51cdf0e10cSrcweir<tablecell> 524702cb60Smseidel<paragraph role="tablehead" id="par_id3149944" xml-lang="en-US" l10n="U">D</paragraph> 53cdf0e10cSrcweir</tablecell> 54cdf0e10cSrcweir</tablerow> 55cdf0e10cSrcweir<tablerow> 56cdf0e10cSrcweir<tablecell> 574702cb60Smseidel<paragraph role="tablecontent" id="par_id3150457" xml-lang="en-US" l10n="U"><emph>2</emph></paragraph> 58cdf0e10cSrcweir</tablecell> 59cdf0e10cSrcweir<tablecell> 604702cb60Smseidel<paragraph role="tablecontent" id="par_id3150024" xml-lang="en-US" l10n="U">x <item type="input">value</item></paragraph> 61cdf0e10cSrcweir</tablecell> 62cdf0e10cSrcweir<tablecell> 634702cb60Smseidel<paragraph role="tablecontent" id="par_id3148725" xml-lang="en-US" l10n="U">y <item type="input">value</item></paragraph> 64cdf0e10cSrcweir</tablecell> 65cdf0e10cSrcweir</tablerow> 66cdf0e10cSrcweir<tablerow> 67cdf0e10cSrcweir<tablecell> 684702cb60Smseidel<paragraph role="tablecontent" id="par_id3150480" xml-lang="en-US" l10n="U"><emph>3</emph></paragraph> 69cdf0e10cSrcweir</tablecell> 70cdf0e10cSrcweir<tablecell> 714702cb60Smseidel<paragraph role="tablecontent" id="par_id3148440" xml-lang="en-US" l10n="U"><item type="input">-5</item></paragraph> 72cdf0e10cSrcweir</tablecell> 73cdf0e10cSrcweir<tablecell> 744702cb60Smseidel<paragraph role="tablecontent" id="par_id3148888" xml-lang="en-US" l10n="U"><item type="input">-3</item></paragraph> 75cdf0e10cSrcweir</tablecell> 76cdf0e10cSrcweir</tablerow> 77cdf0e10cSrcweir<tablerow> 78cdf0e10cSrcweir<tablecell> 794702cb60Smseidel<paragraph role="tablecontent" id="par_id3153034" xml-lang="en-US" l10n="U"><emph>4</emph></paragraph> 80cdf0e10cSrcweir</tablecell> 81cdf0e10cSrcweir<tablecell> 824702cb60Smseidel<paragraph role="tablecontent" id="par_id3150139" xml-lang="en-US" l10n="U"><item type="input">-2</item></paragraph> 83cdf0e10cSrcweir</tablecell> 84cdf0e10cSrcweir<tablecell> 854702cb60Smseidel<paragraph role="tablecontent" id="par_id3149542" xml-lang="en-US" l10n="U"><item type="input">0</item></paragraph> 86cdf0e10cSrcweir</tablecell> 87cdf0e10cSrcweir</tablerow> 88cdf0e10cSrcweir<tablerow> 89cdf0e10cSrcweir<tablecell> 904702cb60Smseidel<paragraph role="tablecontent" id="par_id3149188" xml-lang="en-US" l10n="U"><emph>5</emph></paragraph> 91cdf0e10cSrcweir</tablecell> 92cdf0e10cSrcweir<tablecell> 934702cb60Smseidel<paragraph role="tablecontent" id="par_id3153329" xml-lang="en-US" l10n="U"><item type="input">-1</item></paragraph> 94cdf0e10cSrcweir</tablecell> 95cdf0e10cSrcweir<tablecell> 964702cb60Smseidel<paragraph role="tablecontent" id="par_id3155257" xml-lang="en-US" l10n="U"><item type="input">1</item></paragraph> 97cdf0e10cSrcweir</tablecell> 98cdf0e10cSrcweir</tablerow> 99cdf0e10cSrcweir<tablerow> 100cdf0e10cSrcweir<tablecell> 1014702cb60Smseidel<paragraph role="tablecontent" id="par_id3145142" xml-lang="en-US" l10n="U"><emph>6</emph></paragraph> 102cdf0e10cSrcweir</tablecell> 103cdf0e10cSrcweir<tablecell> 1044702cb60Smseidel<paragraph role="tablecontent" id="par_id3149956" xml-lang="en-US" l10n="U"><item type="input">0</item></paragraph> 105cdf0e10cSrcweir</tablecell> 106cdf0e10cSrcweir<tablecell> 1074702cb60Smseidel<paragraph role="tablecontent" id="par_id3145594" xml-lang="en-US" l10n="U"><item type="input">3</item></paragraph> 108cdf0e10cSrcweir</tablecell> 109cdf0e10cSrcweir</tablerow> 110cdf0e10cSrcweir<tablerow> 111cdf0e10cSrcweir<tablecell> 1124702cb60Smseidel<paragraph role="tablecontent" id="par_id3153113" xml-lang="en-US" l10n="U"><emph>7</emph></paragraph> 113cdf0e10cSrcweir</tablecell> 114cdf0e10cSrcweir<tablecell> 1154702cb60Smseidel<paragraph role="tablecontent" id="par_id3148573" xml-lang="en-US" l10n="U"><item type="input">2</item></paragraph> 116cdf0e10cSrcweir</tablecell> 117cdf0e10cSrcweir<tablecell> 1184702cb60Smseidel<paragraph role="tablecontent" id="par_id3145166" xml-lang="en-US" l10n="U"><item type="input">4</item></paragraph> 119cdf0e10cSrcweir</tablecell> 120cdf0e10cSrcweir</tablerow> 121cdf0e10cSrcweir<tablerow> 122cdf0e10cSrcweir<tablecell> 1234702cb60Smseidel<paragraph role="tablecontent" id="par_id3157998" xml-lang="en-US" l10n="U"><emph>8</emph></paragraph> 124cdf0e10cSrcweir</tablecell> 125cdf0e10cSrcweir<tablecell> 1264702cb60Smseidel<paragraph role="tablecontent" id="par_id3150018" xml-lang="en-US" l10n="U"><item type="input">4</item></paragraph> 127cdf0e10cSrcweir</tablecell> 128cdf0e10cSrcweir<tablecell> 1294702cb60Smseidel<paragraph role="tablecontent" id="par_id3150129" xml-lang="en-US" l10n="U"><item type="input">6</item></paragraph> 130cdf0e10cSrcweir</tablecell> 131cdf0e10cSrcweir</tablerow> 132cdf0e10cSrcweir<tablerow> 133cdf0e10cSrcweir<tablecell> 1344702cb60Smseidel<paragraph role="tablecontent" id="par_id3145245" xml-lang="en-US" l10n="U"><emph>9</emph></paragraph> 135cdf0e10cSrcweir</tablecell> 136cdf0e10cSrcweir<tablecell> 1374702cb60Smseidel<paragraph role="tablecontent" id="par_id3148389" xml-lang="en-US" l10n="U"><item type="input">6</item></paragraph> 138cdf0e10cSrcweir</tablecell> 139cdf0e10cSrcweir<tablecell> 1404702cb60Smseidel<paragraph role="tablecontent" id="par_id3156068" xml-lang="en-US" l10n="U"><item type="input">8</item></paragraph> 141cdf0e10cSrcweir</tablecell> 142cdf0e10cSrcweir</tablerow> 143cdf0e10cSrcweir</table> 144cdf0e10cSrcweir<sort order="asc"> 145cdf0e10cSrcweir<section id="info"> 14682a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3691824"> 14782a98929Smseidel<bookmark_value>INFO function</bookmark_value> 148cdf0e10cSrcweir</bookmark> 149cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_INFO" id="bm_id5369426" localize="false"/> 150cdf0e10cSrcweir<paragraph role="heading" id="hd_id5787224" xml-lang="en-US" level="2" l10n="NEW">INFO</paragraph> 151cdf0e10cSrcweir<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> 152cdf0e10cSrcweir<paragraph role="heading" id="hd_id7693411" xml-lang="en-US" level="3" l10n="NEW">Syntax</paragraph> 153cdf0e10cSrcweir<paragraph role="code" id="par_id3928952" xml-lang="en-US" l10n="NEW">INFO("Type")</paragraph> 154cdf0e10cSrcweir<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> 155cdf0e10cSrcweir<table id="tbl_id1342204"> 156cdf0e10cSrcweir<tablerow> 157cdf0e10cSrcweir<tablecell> 158cdf0e10cSrcweir<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> 159cdf0e10cSrcweir</tablecell> 160cdf0e10cSrcweir<tablecell> 161cdf0e10cSrcweir<paragraph role="tablehead" id="par_id8360850" xml-lang="en-US" l10n="NEW">Return value</paragraph> 162cdf0e10cSrcweir</tablecell> 163cdf0e10cSrcweir</tablerow> 164cdf0e10cSrcweir<tablerow> 165cdf0e10cSrcweir<tablecell> 166cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id9648731" xml-lang="en-US" l10n="NEW">"osversion"</paragraph> 167cdf0e10cSrcweir</tablecell> 168cdf0e10cSrcweir<tablecell> 169cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id908841" xml-lang="en-US" l10n="NEW">Always "Windows (32-bit) NT 5.01", for compatibility reasons</paragraph> 170cdf0e10cSrcweir</tablecell> 171cdf0e10cSrcweir</tablerow> 172cdf0e10cSrcweir<tablerow> 173cdf0e10cSrcweir<tablecell> 174cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id8193914" xml-lang="en-US" l10n="NEW">"system"</paragraph> 175cdf0e10cSrcweir</tablecell> 176cdf0e10cSrcweir<tablecell> 177cdf0e10cSrcweir<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> 178cdf0e10cSrcweir</tablecell> 179cdf0e10cSrcweir</tablerow> 180cdf0e10cSrcweir<tablerow> 181cdf0e10cSrcweir<tablecell> 182cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id2701803" xml-lang="en-US" l10n="NEW">"release"</paragraph> 183cdf0e10cSrcweir</tablecell> 184cdf0e10cSrcweir<tablecell> 185cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id2136295" xml-lang="en-US" l10n="NEW">The product release identifier, for example "300m25(Build:9876)"</paragraph> 186cdf0e10cSrcweir</tablecell> 187cdf0e10cSrcweir</tablerow> 188cdf0e10cSrcweir<tablerow> 189cdf0e10cSrcweir<tablecell> 190cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id9200109" xml-lang="en-US" l10n="NEW">"numfile"</paragraph> 191cdf0e10cSrcweir</tablecell> 192cdf0e10cSrcweir<tablecell> 193cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id4186223" xml-lang="en-US" l10n="NEW">Always 1, for compatibility reasons</paragraph> 194cdf0e10cSrcweir</tablecell> 195cdf0e10cSrcweir</tablerow> 196cdf0e10cSrcweir<tablerow> 197cdf0e10cSrcweir<tablecell> 198cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id5766472" xml-lang="en-US" l10n="NEW">"recalc"</paragraph> 199cdf0e10cSrcweir</tablecell> 200cdf0e10cSrcweir<tablecell> 201cdf0e10cSrcweir<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> 202cdf0e10cSrcweir</tablecell> 203cdf0e10cSrcweir</tablerow> 204cdf0e10cSrcweir</table> 205cdf0e10cSrcweir<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> 206cdf0e10cSrcweir<paragraph role="heading" id="hd_id5459456" xml-lang="en-US" level="3" l10n="NEW">Example</paragraph> 207*666afc3eSmseidel<paragraph role="paragraph" id="par_id3994567" xml-lang="en-US" l10n="NEW"><item type="input">=INFO("release")</item> returns the product release number of the %PRODUCTNAME in use.<comment>Do not translate "release"</comment></paragraph> 208*666afc3eSmseidel<paragraph role="paragraph" id="par_id2873622" xml-lang="en-US" l10n="NEW"><item type="input">=INFO(D5)</item> with cell <item type="literal">D5</item> containing a text string <item type="literal">system</item> returns the operating system type.<comment>Do not translate the hlp_literal system</comment></paragraph> 209cdf0e10cSrcweir</section> 210cdf0e10cSrcweir<section id="current"> 21182a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3155625"> 21282a98929Smseidel<bookmark_value>CURRENT function</bookmark_value> 213cdf0e10cSrcweir</bookmark> 214cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_AKTUELL" id="bm_id3145295" localize="false"/> 2154702cb60Smseidel<paragraph role="heading" id="hd_id3155625" xml-lang="en-US" level="2" l10n="U">CURRENT</paragraph> 2164702cb60Smseidel<paragraph role="paragraph" id="par_id3157975" xml-lang="en-US" l10n="CHG"><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> 2174702cb60Smseidel<paragraph role="heading" id="hd_id3148880" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 2184702cb60Smseidel<paragraph role="code" id="par_id3150930" xml-lang="en-US" l10n="U">CURRENT()</paragraph> 2194702cb60Smseidel<paragraph role="heading" id="hd_id3145629" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 220*666afc3eSmseidel<paragraph role="paragraph" id="par_id5919064" xml-lang="en-US" l10n="NEW"><item type="input">=1+2+CURRENT()</item> 221cdf0e10cSrcweir</paragraph> 222cdf0e10cSrcweir<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> 223*666afc3eSmseidel<paragraph role="paragraph" id="par_id5863826" xml-lang="en-US" l10n="NEW"><item type="input">=A2+B2+STYLE(IF(CURRENT()>10;”Red”;”Default”))</item> 224cdf0e10cSrcweir</paragraph> 225cdf0e10cSrcweir<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> 226*666afc3eSmseidel<paragraph role="paragraph" id="par_id7318643" xml-lang="en-US" l10n="NEW"><item type="input">="choo"&CURRENT()</item> 227cdf0e10cSrcweir</paragraph> 228cdf0e10cSrcweir<paragraph role="paragraph" id="par_id6019165" xml-lang="en-US" l10n="NEW">The example returns choochoo.</paragraph> 229cdf0e10cSrcweir</section> 230cdf0e10cSrcweir<section id="formula"> 23182a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3150688"> 23282a98929Smseidel<bookmark_value>FORMULA function</bookmark_value> 233cdf0e10cSrcweir<bookmark_value>formula cells;displaying formulas in other cells</bookmark_value> 234cdf0e10cSrcweir<bookmark_value>displaying;formulas at any position</bookmark_value> 235cdf0e10cSrcweir</bookmark><comment>mw added "formula cells;" and "displaying;"</comment> 236cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FORMEL" id="bm_id3155373" localize="false"/> 237*666afc3eSmseidel<paragraph role="heading" id="hd_id3150688" xml-lang="en-US" level="2" l10n="U">FORMULA</paragraph> 238*666afc3eSmseidel<paragraph role="paragraph" id="par_id3158417" xml-lang="en-US" l10n="CHG"><ahelp hid="HID_FUNC_FORMEL">Displays the formula of a formula cell as a text string.</ahelp></paragraph> 239*666afc3eSmseidel<paragraph role="heading" id="hd_id3154954" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 240*666afc3eSmseidel<paragraph role="code" id="par_id3147535" xml-lang="en-US" l10n="CHG">FORMULA(Reference)</paragraph> 241cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3014313" xml-lang="en-US" l10n="NEW"> 242cdf0e10cSrcweir<emph>Reference</emph> is a reference to a cell containing a formula.</paragraph> 243cdf0e10cSrcweir<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> 244*666afc3eSmseidel<paragraph role="heading" id="hd_id3152820" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 245*666afc3eSmseidel<paragraph role="paragraph" id="par_id3153179" xml-lang="en-US" l10n="CHG">If cell A8 contains the formula <item type="input">=SUM(1;2;3)</item> then</paragraph> 246*666afc3eSmseidel<paragraph role="paragraph" id="par_id3153923" xml-lang="en-US" l10n="CHG"><item type="input">=FORMULA(A8)</item> returns the text =SUM(1;2;3).</paragraph> 247cdf0e10cSrcweir</section> 248cdf0e10cSrcweir<section id="isref"> 24982a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3155409"> 25082a98929Smseidel<bookmark_value>ISREF function</bookmark_value> 251cdf0e10cSrcweir<bookmark_value>references;testing cell contents</bookmark_value> 252cdf0e10cSrcweir<bookmark_value>cell contents;testing for references</bookmark_value> 253cdf0e10cSrcweir</bookmark><comment>mw added "references;" and "cell contents;"</comment> 254cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTBEZUG" id="bm_id3149774" localize="false"/> 255*666afc3eSmseidel<paragraph role="heading" id="hd_id3155409" xml-lang="en-US" level="2" l10n="U">ISREF</paragraph> 256*666afc3eSmseidel<paragraph role="paragraph" id="par_id3153723" xml-lang="en-US" l10n="CHG"><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> 257cdf0e10cSrcweir<embed href="text/shared/00/00000001.xhp#wahr"/> 258*666afc3eSmseidel<paragraph role="heading" id="hd_id3147175" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 259*666afc3eSmseidel<paragraph role="code" id="par_id3149821" xml-lang="en-US" l10n="U">ISREF(Value)</paragraph> 260*666afc3eSmseidel<paragraph role="paragraph" id="par_id3146152" xml-lang="en-US" l10n="U"><emph>Value</emph> is the value to be tested, to determine whether it is a reference.</paragraph> 261*666afc3eSmseidel<paragraph role="heading" id="hd_id3083448" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 262*666afc3eSmseidel<paragraph role="paragraph" id="par_id3154317" xml-lang="en-US" l10n="CHG"><item type="input">=ISREF(C5)</item> returns the result TRUE because C5 is a valid reference.</paragraph> 263*666afc3eSmseidel<paragraph role="paragraph" id="par_id9728072" xml-lang="en-US" l10n="CHG"><item type="input">=ISREF("abcdef")</item> returns always FALSE because a text can never be a reference.</paragraph> 264*666afc3eSmseidel<paragraph role="paragraph" id="par_id2131544" xml-lang="en-US" l10n="NEW"><item type="input">=ISREF(4)</item> returns FALSE.</paragraph> 265*666afc3eSmseidel<paragraph role="paragraph" id="par_id4295480" xml-lang="en-US" l10n="NEW"><item type="input">=ISREF(INDIRECT("A6"))</item> returns TRUE, because INDIRECT is a function that returns a reference.</paragraph> 266*666afc3eSmseidel<paragraph role="paragraph" id="par_id3626819" xml-lang="en-US" l10n="NEW"><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> 267cdf0e10cSrcweir</section> 268cdf0e10cSrcweir<section id="iserr"> 26982a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3154812"> 27082a98929Smseidel<bookmark_value>ISERR function</bookmark_value> 271cdf0e10cSrcweir<bookmark_value>error codes;controlling</bookmark_value> 272cdf0e10cSrcweir</bookmark><comment>mw added "error codes,"</comment> 273cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTFEHL" id="bm_id3145081" localize="false"/> 274*666afc3eSmseidel<paragraph role="heading" id="hd_id3154812" xml-lang="en-US" level="2" l10n="U">ISERR</paragraph> 275*666afc3eSmseidel<paragraph role="paragraph" id="par_id3149282" xml-lang="en-US" l10n="CHG"><ahelp hid="HID_FUNC_ISTFEHL">Tests for error conditions, except the #N/A error value, and returns TRUE or FALSE.</ahelp></paragraph> 276cdf0e10cSrcweir<embed href="text/shared/00/00000001.xhp#wahr"/> 277*666afc3eSmseidel<paragraph role="heading" id="hd_id3149450" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 278*666afc3eSmseidel<paragraph role="code" id="par_id3156312" xml-lang="en-US" l10n="U">ISERR(Value)</paragraph> 279*666afc3eSmseidel<paragraph role="paragraph" id="par_id3146857" xml-lang="en-US" l10n="CHG"> 280cdf0e10cSrcweir<emph>Value</emph> is any value or expression which is tested to see whether an error value other than #N/A is present.</paragraph> 281*666afc3eSmseidel<paragraph role="heading" id="hd_id3153212" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 282*666afc3eSmseidel<paragraph role="paragraph" id="par_id3153276" xml-lang="en-US" l10n="CHG"><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> 283*666afc3eSmseidel<paragraph role="paragraph" id="par_id8456984" xml-lang="en-US" l10n="NEW"><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> 284cdf0e10cSrcweir</section> 285cdf0e10cSrcweir<section id="iserror"> 28682a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3147081"> 28782a98929Smseidel<bookmark_value>ISERROR function</bookmark_value> 288cdf0e10cSrcweir<bookmark_value>recognizing;general errors</bookmark_value> 289cdf0e10cSrcweir</bookmark><comment>mw added "recognizing;"</comment> 290cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTFEHLER" id="bm_id3145206" localize="false"/> 291*666afc3eSmseidel<paragraph role="heading" id="hd_id3147081" xml-lang="en-US" level="2" l10n="U">ISERROR</paragraph> 292*666afc3eSmseidel<paragraph role="paragraph" id="par_id3156316" xml-lang="en-US" l10n="CHG"><ahelp hid="HID_FUNC_ISTFEHLER">Tests for error conditions, including the #N/A error value, and returns TRUE or FALSE.</ahelp></paragraph> 293cdf0e10cSrcweir<embed href="text/shared/00/00000001.xhp#wahr"/> 294*666afc3eSmseidel<paragraph role="heading" id="hd_id3147569" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 295*666afc3eSmseidel<paragraph role="code" id="par_id3153155" xml-lang="en-US" l10n="U">ISERROR(Value)</paragraph> 296*666afc3eSmseidel<paragraph role="paragraph" id="par_id3154047" xml-lang="en-US" l10n="CHG"> 297cdf0e10cSrcweir<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> 298*666afc3eSmseidel<paragraph role="heading" id="hd_id3155994" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 299*666afc3eSmseidel<paragraph role="paragraph" id="par_id3150256" xml-lang="en-US" l10n="CHG"><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> 300*666afc3eSmseidel<paragraph role="paragraph" id="par_id1889095" xml-lang="en-US" l10n="NEW"><item type="input">=ISERROR(C9)</item> where cell C9 contains <item type="input">=NA()</item> returns TRUE.</paragraph> 301cdf0e10cSrcweir</section> 302cdf0e10cSrcweir<section id="isformula"> 30382a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3153618"> 30482a98929Smseidel<bookmark_value>ISFORMULA function</bookmark_value> 305cdf0e10cSrcweir<bookmark_value>recognizing formula cells</bookmark_value> 306cdf0e10cSrcweir<bookmark_value>formula cells;recognizing</bookmark_value> 307cdf0e10cSrcweir</bookmark><comment>mw inserted "recognizing..." and "formula cells;"</comment> 308cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTFORMEL" id="bm_id3154740" localize="false"/> 309*666afc3eSmseidel<paragraph role="heading" id="hd_id3153618" xml-lang="en-US" level="2" l10n="U">ISFORMULA</paragraph> 310*666afc3eSmseidel<paragraph role="paragraph" id="par_id3149138" xml-lang="en-US" l10n="U"><ahelp hid="HID_FUNC_ISTFORMEL">Returns TRUE if a cell is a formula cell.</ahelp></paragraph> 311cdf0e10cSrcweir<embed href="text/shared/00/00000001.xhp#wahr"/> 312*666afc3eSmseidel<paragraph role="heading" id="hd_id3155100" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 313*666afc3eSmseidel<paragraph role="code" id="par_id3143230" xml-lang="en-US" l10n="U">ISFORMULA(Reference)</paragraph> 314*666afc3eSmseidel<paragraph role="paragraph" id="par_id3150150" xml-lang="en-US" l10n="U"><emph>Reference</emph> indicates the reference to a cell in which a test will be performed to determine if it contains a formula.</paragraph> 315*666afc3eSmseidel<paragraph role="heading" id="hd_id3147491" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 316*666afc3eSmseidel<paragraph role="paragraph" id="par_id3159182" xml-lang="en-US" l10n="CHG"><item type="input">=ISFORMULA(C4)</item> returns FALSE if the cell C4 contains the number <item type="input">5</item>.</paragraph> 317cdf0e10cSrcweir</section> 318cdf0e10cSrcweir<section id="iseven_add"> 31982a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3149760"> 32082a98929Smseidel<bookmark_value>ISEVEN_ADD function</bookmark_value> 321cdf0e10cSrcweir</bookmark> 322cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_ISEVEN" id="bm_id3146094" localize="false"/> 323*666afc3eSmseidel<paragraph role="heading" id="hd_id3149760" xml-lang="en-US" level="2">ISEVEN_ADD</paragraph> 324*666afc3eSmseidel<paragraph role="paragraph" id="par_id3147253" xml-lang="en-US" l10n="CHG"><ahelp hid="HID_AAI_FUNC_ISEVEN">Tests for even numbers. Returns 1 if the number divided by 2 returns a whole number.</ahelp></paragraph> 325cdf0e10cSrcweir<embed href="text/scalc/01/04060102.xhp#ADD_note"/> 326*666afc3eSmseidel<paragraph role="heading" id="hd_id3152799" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 327*666afc3eSmseidel<paragraph role="code" id="par_id3149202" xml-lang="en-US" l10n="U">ISEVEN_ADD(Number)</paragraph> 328*666afc3eSmseidel<paragraph role="paragraph" id="par_id3151168" xml-lang="en-US" l10n="CHG"><emph>Number</emph> is the number to be tested.</paragraph> 329*666afc3eSmseidel<paragraph role="heading" id="hd_id3150115" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 330*666afc3eSmseidel<paragraph role="paragraph" id="par_id3153904" xml-lang="en-US" l10n="U"><item type="input">=ISEVEN_ADD(5)</item> returns 0.</paragraph> 331*666afc3eSmseidel<paragraph role="paragraph" id="par_id6238308" xml-lang="en-US" l10n="NEW"><item type="input">=ISEVEN_ADD(A1)</item> returns 1 if cell A1 contains the number <item type="input">2</item>.</paragraph> 332cdf0e10cSrcweir</section> 333cdf0e10cSrcweir<section id="isnontext"> 33482a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3154692"> 33582a98929Smseidel<bookmark_value>ISNONTEXT function</bookmark_value> 336cdf0e10cSrcweir<bookmark_value>cell contents;no text</bookmark_value> 337cdf0e10cSrcweir</bookmark><comment>mw added "cell contents;"</comment> 338cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTKTEXT" id="bm_id3159342" localize="false"/> 339*666afc3eSmseidel<paragraph role="heading" id="hd_id3154692" xml-lang="en-US" level="2" l10n="U">ISNONTEXT</paragraph> 340*666afc3eSmseidel<paragraph role="paragraph" id="par_id3155330" xml-lang="en-US" l10n="U"><ahelp hid="HID_FUNC_ISTKTEXT">Tests if the cell contents are text or numbers, and returns FALSE if the contents are text.</ahelp></paragraph> 341cdf0e10cSrcweir<paragraph role="paragraph" id="par_id5719779" xml-lang="en-US" l10n="NEW">If an error occurs, the function returns TRUE.</paragraph> 342*666afc3eSmseidel<paragraph role="heading" id="hd_id3154931" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 343*666afc3eSmseidel<paragraph role="code" id="par_id3148829" xml-lang="en-US" l10n="U">ISNONTEXT(Value)</paragraph> 344*666afc3eSmseidel<paragraph role="paragraph" id="par_id3146992" xml-lang="en-US" l10n="U"><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> 345*666afc3eSmseidel<paragraph role="heading" id="hd_id3150525" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 346*666afc3eSmseidel<paragraph role="paragraph" id="par_id3149906" xml-lang="en-US" l10n="CHG"><item type="input">=ISNONTEXT(D2)</item> returns FALSE if cell D2 contains the text <item type="input">abcdef</item>.</paragraph> 347*666afc3eSmseidel<paragraph role="paragraph" id="par_id3150777" xml-lang="en-US" l10n="CHG"><item type="input">=ISNONTEXT(D9)</item> returns TRUE if cell D9 contains the number <item type="input">8</item>.</paragraph> 348cdf0e10cSrcweir</section> 349cdf0e10cSrcweir<section id="isblank"> 35082a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3159148"> 35182a98929Smseidel<bookmark_value>ISBLANK function</bookmark_value> 352cdf0e10cSrcweir<bookmark_value>blank cell contents</bookmark_value> 353cdf0e10cSrcweir<bookmark_value>empty cells; recognizing</bookmark_value> 354cdf0e10cSrcweir</bookmark><comment>mw added "blank..." and "empty cells;"</comment> 355cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTLEER" id="bm_id3148940" localize="false"/> 356*666afc3eSmseidel<paragraph role="heading" id="hd_id3159148" xml-lang="en-US" level="2" l10n="U">ISBLANK</paragraph> 357*666afc3eSmseidel<paragraph role="paragraph" id="par_id3148800" xml-lang="en-US" l10n="U"><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> 358cdf0e10cSrcweir<embed href="text/shared/00/00000001.xhp#wahr"/> 359*666afc3eSmseidel<paragraph role="heading" id="hd_id3159162" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 360*666afc3eSmseidel<paragraph role="code" id="par_id3158406" xml-lang="en-US" l10n="U">ISBLANK(Value)</paragraph> 361*666afc3eSmseidel<paragraph role="paragraph" id="par_id3154212" xml-lang="en-US" l10n="U"><emph>Value</emph> is the content to be tested.</paragraph> 362*666afc3eSmseidel<paragraph role="heading" id="hd_id3147508" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 363*666afc3eSmseidel<paragraph role="paragraph" id="par_id3147234" xml-lang="en-US" l10n="U"><item type="input">=ISBLANK(D2)</item> returns FALSE as a result.</paragraph> 364cdf0e10cSrcweir</section> 365cdf0e10cSrcweir<section id="islogical"> 36682a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3155356"> 36782a98929Smseidel<bookmark_value>ISLOGICAL function</bookmark_value> 368cdf0e10cSrcweir<bookmark_value>number formats;logical</bookmark_value> 369cdf0e10cSrcweir<bookmark_value>logical number formats</bookmark_value> 370cdf0e10cSrcweir</bookmark><comment>mw added "number formats;" and "logical..."</comment> 371cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTLOG" id="bm_id3158424" localize="false"/> 372*666afc3eSmseidel<paragraph role="heading" id="hd_id3155356" xml-lang="en-US" level="2" l10n="U">ISLOGICAL</paragraph> 373*666afc3eSmseidel<paragraph role="paragraph" id="par_id3148926" xml-lang="en-US" l10n="CHG"><ahelp hid="HID_FUNC_ISTLOG">Tests for a logical value (TRUE or FALSE).</ahelp></paragraph> 374cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3541062" xml-lang="en-US" l10n="NEW">If an error occurs, the function returns FALSE.</paragraph> 375*666afc3eSmseidel<paragraph role="heading" id="hd_id3149162" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 376*666afc3eSmseidel<paragraph role="code" id="par_id3148918" xml-lang="en-US" l10n="U">ISLOGICAL(Value)</paragraph> 377*666afc3eSmseidel<paragraph role="paragraph" id="par_id3146946" xml-lang="en-US" l10n="CHG">Returns TRUE if <emph>Value</emph> is a logical value (TRUE or FALSE), and returns FALSE otherwise.</paragraph> 378*666afc3eSmseidel<paragraph role="heading" id="hd_id3150709" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 379*666afc3eSmseidel<paragraph role="paragraph" id="par_id3166442" xml-lang="en-US" l10n="CHG"><item type="input">=ISLOGICAL(99)</item> returns FALSE, because 99 is a number, not a logical value.</paragraph> 380*666afc3eSmseidel<paragraph role="paragraph" id="par_id3556016" xml-lang="en-US" l10n="NEW"><item type="input">=ISLOGICAL(ISNA(D4))</item> returns TRUE whatever the contents of cell D4, because ISNA() returns a logical value.</paragraph> 381cdf0e10cSrcweir</section> 382cdf0e10cSrcweir<section id="isna"> 38382a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3153685"> 38482a98929Smseidel<bookmark_value>ISNA function</bookmark_value> 385cdf0e10cSrcweir<bookmark_value>#N/A error;recognizing</bookmark_value> 386cdf0e10cSrcweir</bookmark><comment>mw added "#N/A ..."</comment> 387cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTNV" id="bm_id3159273" localize="false"/> 388*666afc3eSmseidel<paragraph role="heading" id="hd_id3153685" xml-lang="en-US" level="2" l10n="U">ISNA</paragraph> 389*666afc3eSmseidel<paragraph role="paragraph" id="par_id3149105" xml-lang="en-US" l10n="U"><ahelp hid="HID_FUNC_ISTNV">Returns TRUE if a cell contains the #N/A (value not available) error value.</ahelp></paragraph> 390cdf0e10cSrcweir<paragraph role="paragraph" id="par_id6018860" xml-lang="en-US" l10n="NEW">If an error occurs, the function returns FALSE.</paragraph> 391*666afc3eSmseidel<paragraph role="heading" id="hd_id3152947" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 392*666afc3eSmseidel<paragraph role="code" id="par_id3153748" xml-lang="en-US" l10n="U">ISNA(Value)</paragraph> 393*666afc3eSmseidel<paragraph role="paragraph" id="par_id3152884" xml-lang="en-US" l10n="U"><emph>Value</emph> is the value or expression to be tested.</paragraph> 394*666afc3eSmseidel<paragraph role="heading" id="hd_id3149964" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 395*666afc3eSmseidel<paragraph role="paragraph" id="par_id3154852" xml-lang="en-US" l10n="U"><item type="input">=ISNA(D3)</item> returns FALSE as a result.</paragraph> 396cdf0e10cSrcweir</section> 397cdf0e10cSrcweir<section id="istext"> 39882a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3149426"> 39982a98929Smseidel<bookmark_value>ISTEXT function</bookmark_value> 400cdf0e10cSrcweir<bookmark_value>cell contents;text</bookmark_value> 401cdf0e10cSrcweir</bookmark> 402cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTTEXT" id="bm_id3148468" localize="false"/> 403*666afc3eSmseidel<paragraph role="heading" id="hd_id3149426" xml-lang="en-US" level="2" l10n="U">ISTEXT</paragraph> 404*666afc3eSmseidel<paragraph role="paragraph" id="par_id3145368" xml-lang="en-US" l10n="U"><ahelp hid="HID_FUNC_ISTTEXT">Returns TRUE if the cell contents refer to text.</ahelp></paragraph> 405cdf0e10cSrcweir<paragraph role="paragraph" id="par_id6779686" xml-lang="en-US" l10n="NEW">If an error occurs, the function returns FALSE.</paragraph> 406*666afc3eSmseidel<paragraph role="heading" id="hd_id3154332" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 407*666afc3eSmseidel<paragraph role="code" id="par_id3148649" xml-lang="en-US" l10n="U">ISTEXT(Value)</paragraph> 408*666afc3eSmseidel<paragraph role="paragraph" id="par_id3150417" xml-lang="en-US" l10n="U"><emph>Value</emph> is a value, number, Boolean value, or an error value to be tested.</paragraph> 409*666afc3eSmseidel<paragraph role="heading" id="hd_id3149239" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 410*666afc3eSmseidel<paragraph role="paragraph" id="par_id3144756" xml-lang="en-US" l10n="CHG"><item type="input">=ISTEXT(D9)</item> returns TRUE if cell D9 contains the text <item type="input">abcdef</item>.</paragraph> 411*666afc3eSmseidel<paragraph role="paragraph" id="par_id3148416" xml-lang="en-US" l10n="CHG"><item type="input">=ISTEXT(C3)</item> returns FALSE if cell C3 contains the number <item type="input">3</item>.</paragraph> 412cdf0e10cSrcweir</section> 413cdf0e10cSrcweir<section id="isodd_add"> 41482a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3153939"> 41582a98929Smseidel<bookmark_value>ISODD_ADD function</bookmark_value> 416cdf0e10cSrcweir</bookmark> 417cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_ISODD" id="bm_id3149927" localize="false"/> 418*666afc3eSmseidel<paragraph role="heading" id="hd_id3153939" xml-lang="en-US" level="2">ISODD_ADD</paragraph> 419*666afc3eSmseidel<paragraph role="paragraph" id="par_id3153538" xml-lang="en-US" l10n="U"><ahelp hid="HID_AAI_FUNC_ISODD">Returns TRUE (1) if the number does not return a whole number when divided by 2.</ahelp></paragraph> 420cdf0e10cSrcweir<embed href="text/scalc/01/04060102.xhp#ADD_note"/> 421*666afc3eSmseidel<paragraph role="heading" id="hd_id3145601" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 422*666afc3eSmseidel<paragraph role="code" id="par_id3149485" xml-lang="en-US" l10n="U">ISODD_ADD(Number)</paragraph> 423*666afc3eSmseidel<paragraph role="paragraph" id="par_id3153315" xml-lang="en-US" l10n="U"><emph>Number</emph> is the number to be tested.</paragraph> 424*666afc3eSmseidel<paragraph role="heading" id="hd_id3143274" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 425*666afc3eSmseidel<paragraph role="paragraph" id="par_id3154793" xml-lang="en-US" l10n="U"><item type="input">=ISODD_ADD(5)</item> returns 1.</paragraph> 426cdf0e10cSrcweir</section> 427cdf0e10cSrcweir<section id="isnumber"> 42882a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3148688"> 42982a98929Smseidel<bookmark_value>ISNUMBER function</bookmark_value> 430cdf0e10cSrcweir<bookmark_value>cell contents;numbers</bookmark_value> 431cdf0e10cSrcweir</bookmark><comment>mw added "cell contents;"</comment> 432cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTZAHL" id="bm_id3149587" localize="false"/> 433*666afc3eSmseidel<paragraph role="heading" id="hd_id3148688" xml-lang="en-US" level="2" l10n="U">ISNUMBER</paragraph> 434*666afc3eSmseidel<paragraph role="paragraph" id="par_id3154618" xml-lang="en-US" l10n="U"><ahelp hid="HID_FUNC_ISTZAHL">Returns TRUE if the value refers to a number.</ahelp></paragraph> 435cdf0e10cSrcweir<embed href="text/shared/00/00000001.xhp#wahr"/> 436*666afc3eSmseidel<paragraph role="heading" id="hd_id3152769" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 437*666afc3eSmseidel<paragraph role="code" id="par_id3150595" xml-lang="en-US" l10n="U">ISNUMBER(Value)</paragraph> 438*666afc3eSmseidel<paragraph role="paragraph" id="par_id3150351" xml-lang="en-US" l10n="U"><emph>Value</emph> is any expression to be tested to determine whether it is a number or text.</paragraph> 439*666afc3eSmseidel<paragraph role="heading" id="hd_id3146793" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 440*666afc3eSmseidel<paragraph role="paragraph" id="par_id3155614" xml-lang="en-US" l10n="CHG"><item type="input">=ISNUMBER(C3)</item> returns TRUE if the cell C3 contains the number <item type="input">4</item>.</paragraph> 441*666afc3eSmseidel<paragraph role="paragraph" id="par_id3154417" xml-lang="en-US" l10n="CHG"><item type="input">=ISNUMBER(C2)</item> returns FALSE if the cell C2 contains the text <item type="input">abcdef</item>.</paragraph> 442cdf0e10cSrcweir</section> 443cdf0e10cSrcweir<section id="n"> 44482a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3153694"> 44582a98929Smseidel<bookmark_value>N function</bookmark_value> 446cdf0e10cSrcweir</bookmark> 447cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_N" id="bm_id3153786" localize="false"/> 448*666afc3eSmseidel<paragraph role="heading" id="hd_id3153694" xml-lang="en-US" level="2" l10n="U">N</paragraph> 449*666afc3eSmseidel<paragraph role="paragraph" id="par_id3150405" xml-lang="en-US" l10n="CHG"><ahelp hid="HID_FUNC_N">Returns the numeric value of the given parameter. Returns 0 if parameter is text, FALSE or #NA.</ahelp></paragraph> 450cdf0e10cSrcweir<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> 451*666afc3eSmseidel<paragraph role="heading" id="hd_id3145774" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 452*666afc3eSmseidel<paragraph role="code" id="par_id3153883" xml-lang="en-US" l10n="U">N(Value)</paragraph> 453*666afc3eSmseidel<paragraph role="paragraph" id="par_id3151101" xml-lang="en-US" l10n="CHG"> 454cdf0e10cSrcweir<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> 455*666afc3eSmseidel<paragraph role="heading" id="hd_id3147097" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 456*666afc3eSmseidel<paragraph role="paragraph" id="par_id3154117" xml-lang="en-US" l10n="CHG"><item type="input">=N(123)</item> returns 123</paragraph> 457*666afc3eSmseidel<paragraph role="paragraph" id="par_id2337717" xml-lang="en-US" l10n="NEW"><item type="input">=N(TRUE)</item> returns 1</paragraph> 458*666afc3eSmseidel<paragraph role="paragraph" id="par_id3153781" xml-lang="en-US" l10n="U"><item type="input">=N(FALSE)</item> returns 0</paragraph> 459*666afc3eSmseidel<paragraph role="paragraph" id="par_id3154670" xml-lang="en-US" l10n="U"><item type="input">=N("abc")</item> returns 0</paragraph> 460cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3519089" xml-lang="en-US" l10n="NEW">=N(1/0) returns #DIV/0!</paragraph> 461cdf0e10cSrcweir</section> 462cdf0e10cSrcweir<section id="na"> 46382a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3156275"> 46482a98929Smseidel<bookmark_value>NA function</bookmark_value> 465cdf0e10cSrcweir<bookmark_value>#N/A error;assigning to a cell</bookmark_value> 466cdf0e10cSrcweir</bookmark><comment>mw added "#N/A error;"</comment> 467cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NV" id="bm_id3154569" localize="false"/> 468*666afc3eSmseidel<paragraph role="heading" id="hd_id3156275" xml-lang="en-US" level="2" l10n="U">NA</paragraph> 469*666afc3eSmseidel<paragraph role="paragraph" id="par_id3156161" xml-lang="en-US" l10n="U"><ahelp hid="HID_FUNC_NV">Returns the error value #N/A.</ahelp></paragraph> 470*666afc3eSmseidel<paragraph role="heading" id="hd_id3147532" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 471*666afc3eSmseidel<paragraph role="code" id="par_id3149563" xml-lang="en-US" l10n="U">NA()</paragraph> 472*666afc3eSmseidel<paragraph role="heading" id="hd_id3155128" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 473*666afc3eSmseidel<paragraph role="paragraph" id="par_id3154481" xml-lang="en-US" l10n="U"><item type="input">=NA()</item> converts the contents of the cell into #N/A.</paragraph> 474cdf0e10cSrcweir</section> 475cdf0e10cSrcweir<section id="type"> 47682a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3151255"> 47782a98929Smseidel<bookmark_value>TYPE function</bookmark_value> 478cdf0e10cSrcweir</bookmark> 479cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TYP" id="bm_id3146127" localize="false"/> 480*666afc3eSmseidel<paragraph role="heading" id="hd_id3151255" xml-lang="en-US" level="2" l10n="U">TYPE</paragraph> 481*666afc3eSmseidel<paragraph role="paragraph" id="par_id3155900" xml-lang="en-US" l10n="U"><ahelp hid="HID_FUNC_TYP">Returns the type of value, where 1 = number, 2 = text, 4 = Boolean value, 8 = formula, 16 = error value, 64 = array.</ahelp></paragraph> 482cdf0e10cSrcweir<embed href="text/shared/00/00000001.xhp#wahr"/> 483*666afc3eSmseidel<paragraph role="heading" id="hd_id3149992" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 484*666afc3eSmseidel<paragraph role="code" id="par_id3148400" xml-lang="en-US" l10n="U">TYPE(Value)</paragraph> 485*666afc3eSmseidel<paragraph role="paragraph" id="par_id3150830" xml-lang="en-US" l10n="U"><emph>Value</emph> is a specific value for which the data type is determined.</paragraph> 486*666afc3eSmseidel<paragraph role="heading" id="hd_id3154363" xml-lang="en-US" level="3" l10n="U">Example (see example table above)</paragraph> 487*666afc3eSmseidel<paragraph role="paragraph" id="par_id3153357" xml-lang="en-US" l10n="U"><item type="input">=TYPE(C2)</item> returns 2 as a result.</paragraph> 488*666afc3eSmseidel<paragraph role="paragraph" id="par_id3148980" xml-lang="en-US" l10n="U"><item type="input">=TYPE(D9)</item> returns 1 as a result.</paragraph> 489cdf0e10cSrcweir</section> 490cdf0e10cSrcweir<section id="cell"> 49182a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3155509"> 49282a98929Smseidel<bookmark_value>CELL function</bookmark_value> 493cdf0e10cSrcweir<bookmark_value>cell information</bookmark_value> 494cdf0e10cSrcweir<bookmark_value>information on cells</bookmark_value> 495cdf0e10cSrcweir</bookmark><comment>mw added two entries</comment> 496cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZELLE" id="bm_id3159412" localize="false"/> 497*666afc3eSmseidel<paragraph role="heading" id="hd_id3155509" xml-lang="en-US" level="2" l10n="U">CELL</paragraph> 498*666afc3eSmseidel<paragraph role="paragraph" id="par_id3153196" xml-lang="en-US" l10n="U"><ahelp hid="HID_FUNC_ZELLE">Returns information on address, formatting or contents of a cell.</ahelp></paragraph> 499*666afc3eSmseidel<paragraph role="heading" id="hd_id3149323" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 500*666afc3eSmseidel<paragraph role="code" id="par_id3147355" xml-lang="en-US" l10n="U">CELL("InfoType"; Reference)</paragraph> 501*666afc3eSmseidel<paragraph role="paragraph" id="par_id3154716" xml-lang="en-US" l10n="U"><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> 502cdf0e10cSrcweir<table id="tbl_id3152470"> 503cdf0e10cSrcweir<tablerow> 504cdf0e10cSrcweir<tablecell> 505*666afc3eSmseidel<paragraph role="tablehead" id="par_id3150636" xml-lang="en-US" l10n="U">InfoType</paragraph> 506cdf0e10cSrcweir</tablecell> 507cdf0e10cSrcweir<tablecell> 508*666afc3eSmseidel<paragraph role="tablehead" id="par_id3149344" xml-lang="en-US" l10n="U">Meaning</paragraph> 509cdf0e10cSrcweir</tablecell> 510cdf0e10cSrcweir</tablerow> 511cdf0e10cSrcweir<tablerow> 512cdf0e10cSrcweir<tablecell> 513*666afc3eSmseidel<paragraph role="code" id="par_id3153266" xml-lang="en-US" l10n="U">COL</paragraph> 514cdf0e10cSrcweir</tablecell> 515cdf0e10cSrcweir<tablecell> 516*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3156204" xml-lang="en-US" l10n="U">Returns the number of the referenced column.</paragraph> 517*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3150094" xml-lang="en-US" l10n="U"><item type="input">=CELL("COL";D2)</item> returns 4.</paragraph> 518cdf0e10cSrcweir</tablecell> 519cdf0e10cSrcweir</tablerow> 520cdf0e10cSrcweir<tablerow> 521cdf0e10cSrcweir<tablecell> 522*666afc3eSmseidel<paragraph role="code" id="par_id3151276" xml-lang="en-US" l10n="U">ROW</paragraph> 523cdf0e10cSrcweir</tablecell> 524cdf0e10cSrcweir<tablecell> 525*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3147583" xml-lang="en-US" l10n="U">Returns the number of the referenced row.</paragraph> 526*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3151222" xml-lang="en-US" l10n="U"><item type="input">=CELL("ROW";D2)</item> returns 2.</paragraph> 527cdf0e10cSrcweir</tablecell> 528cdf0e10cSrcweir</tablerow> 529cdf0e10cSrcweir<tablerow> 530cdf0e10cSrcweir<tablecell> 531*666afc3eSmseidel<paragraph role="code" id="par_id3159217" xml-lang="en-US" l10n="U">SHEET</paragraph> 532cdf0e10cSrcweir</tablecell> 533cdf0e10cSrcweir<tablecell> 534*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3151201" xml-lang="en-US" l10n="U">Returns the number of the referenced sheet.</paragraph> 535*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3149169" xml-lang="en-US" l10n="U"><item type="input">=CELL("Sheet";Sheet3.D2)</item> returns 3.</paragraph> 536cdf0e10cSrcweir</tablecell> 537cdf0e10cSrcweir</tablerow> 538cdf0e10cSrcweir<tablerow> 539cdf0e10cSrcweir<tablecell> 540*666afc3eSmseidel<paragraph role="code" id="par_id3149431" xml-lang="en-US" l10n="U">ADDRESS</paragraph> 541cdf0e10cSrcweir</tablecell> 542cdf0e10cSrcweir<tablecell> 543*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3156054" xml-lang="en-US" l10n="U">Returns the absolute address of the referenced cell.</paragraph> 544*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3154136" xml-lang="en-US" l10n="U"><item type="input">=CELL("ADDRESS";D2)</item> returns $D$2.</paragraph> 545*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3159198" xml-lang="en-US" l10n="U"><item type="input">=CELL("ADDRESS";Sheet3.D2)</item> returns $Sheet3.$D$2.</paragraph> 546*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3150245" xml-lang="en-US" l10n="U"><item type="input">=CELL("ADDRESS";'X:\dr\test.ods'#$Sheet1.D2)</item> returns 'file:///X:/dr/test.ods'#$Sheet1.$D$2.</paragraph> 547cdf0e10cSrcweir</tablecell> 548cdf0e10cSrcweir</tablerow> 549cdf0e10cSrcweir<tablerow> 550cdf0e10cSrcweir<tablecell> 551*666afc3eSmseidel<paragraph role="code" id="par_id3146811" xml-lang="en-US" l10n="U">FILENAME</paragraph> 552cdf0e10cSrcweir</tablecell> 553cdf0e10cSrcweir<tablecell> 554*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3151328" xml-lang="en-US" l10n="U">Returns the file name and the sheet number of the referenced cell.</paragraph> 555*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3148896" xml-lang="en-US" l10n="U"><item type="input">=CELL("FILENAME";D2)</item> returns 'file:///X:/dr/own.ods'#$Sheet1, if the formula in the current document X:\dr\own.ods is located in Sheet1.</paragraph> 556*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3155144" xml-lang="en-US" l10n="U"><item type="input">=CELL("FILENAME";'X:\dr\test.ods'#$Sheet1.D2)</item> returns 'file:///X:/dr/test.ods'#$Sheet1.</paragraph> 557cdf0e10cSrcweir</tablecell> 558cdf0e10cSrcweir</tablerow> 559cdf0e10cSrcweir<tablerow> 560cdf0e10cSrcweir<tablecell> 561*666afc3eSmseidel<paragraph role="code" id="par_id3151381" xml-lang="en-US" l10n="U">COORD</paragraph> 562cdf0e10cSrcweir</tablecell> 563cdf0e10cSrcweir<tablecell> 564*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3151004" xml-lang="en-US" l10n="U">Returns the complete cell address in Lotus(TM) notation.</paragraph> 565*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3159104" xml-lang="en-US" l10n="U"><item type="input">=CELL("COORD"; D2)</item> returns $A:$D$2.</paragraph> 566*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3163720" xml-lang="en-US" l10n="U"><item type="input">=CELL("COORD"; Sheet3.D2)</item> returns $C:$D$2.</paragraph> 567cdf0e10cSrcweir</tablecell> 568cdf0e10cSrcweir</tablerow> 569cdf0e10cSrcweir<tablerow> 570cdf0e10cSrcweir<tablecell> 571*666afc3eSmseidel<paragraph role="code" id="par_id3155910" xml-lang="en-US" l10n="U">CONTENTS</paragraph> 572cdf0e10cSrcweir</tablecell> 573cdf0e10cSrcweir<tablecell> 574*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3156041" xml-lang="en-US" l10n="U">Returns the contents of the referenced cell, without any formatting.</paragraph> 575cdf0e10cSrcweir</tablecell> 576cdf0e10cSrcweir</tablerow> 577cdf0e10cSrcweir<tablerow> 578cdf0e10cSrcweir<tablecell> 579*666afc3eSmseidel<paragraph role="code" id="par_id3151069" xml-lang="en-US" l10n="U">TYPE</paragraph> 580cdf0e10cSrcweir</tablecell> 581cdf0e10cSrcweir<tablecell> 582*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3155344" xml-lang="en-US" l10n="U">Returns the type of cell contents.</paragraph> 583*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3145217" xml-lang="en-US" l10n="U">b = blank. empty cell</paragraph> 584*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3155176" xml-lang="en-US" l10n="U">l = label. Text, result of a formula as text</paragraph> 585*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3147280" xml-lang="en-US" l10n="U">v = value. Value, result of a formula as a number</paragraph> 586cdf0e10cSrcweir</tablecell> 587cdf0e10cSrcweir</tablerow> 588cdf0e10cSrcweir<tablerow> 589cdf0e10cSrcweir<tablecell> 590*666afc3eSmseidel<paragraph role="code" id="par_id3156348" xml-lang="en-US" l10n="U">WIDTH</paragraph> 591cdf0e10cSrcweir</tablecell> 592cdf0e10cSrcweir<tablecell> 593*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3154920" xml-lang="en-US" l10n="U">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> 594cdf0e10cSrcweir</tablecell> 595cdf0e10cSrcweir</tablerow> 596cdf0e10cSrcweir<tablerow> 597cdf0e10cSrcweir<tablecell> 598*666afc3eSmseidel<paragraph role="code" id="par_id3152355" xml-lang="en-US" l10n="U">PREFIX</paragraph> 599cdf0e10cSrcweir</tablecell> 600cdf0e10cSrcweir<tablecell> 601*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3154230" xml-lang="en-US" l10n="U">Returns the alignment of the referenced cell.</paragraph> 602*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3155946" xml-lang="en-US" l10n="U">' = align left or left-justified</paragraph> 603*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3147220" xml-lang="en-US" l10n="U">" = align right</paragraph> 604*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3149038" xml-lang="en-US" l10n="U">^ = centered</paragraph> 605*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3153129" xml-lang="en-US" l10n="U">\ = repeating (currently inactive)</paragraph> 606cdf0e10cSrcweir</tablecell> 607cdf0e10cSrcweir</tablerow> 608cdf0e10cSrcweir<tablerow> 609cdf0e10cSrcweir<tablecell> 610*666afc3eSmseidel<paragraph role="code" id="par_id3154406" xml-lang="en-US" l10n="U">PROTECT</paragraph> 611cdf0e10cSrcweir</tablecell> 612cdf0e10cSrcweir<tablecell> 613*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3145127" xml-lang="en-US" l10n="U">Returns the status of the cell protection for the cell.</paragraph> 614*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3155794" xml-lang="en-US" l10n="U">1 = cell is protected</paragraph> 615*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3155072" xml-lang="en-US" l10n="U">0 = cell is not protected</paragraph> 616cdf0e10cSrcweir</tablecell> 617cdf0e10cSrcweir</tablerow> 618cdf0e10cSrcweir<tablerow> 619cdf0e10cSrcweir<tablecell> 620*666afc3eSmseidel<paragraph role="code" id="par_id3156178" xml-lang="en-US" l10n="U">FORMAT</paragraph> 621cdf0e10cSrcweir</tablecell> 622cdf0e10cSrcweir<tablecell> 623*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3150220" xml-lang="en-US" l10n="U">Returns a character string that indicates the number format.</paragraph> 624*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3153824" xml-lang="en-US" l10n="U">, = number with thousands separator</paragraph> 625*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3153837" xml-lang="en-US" l10n="U">F = number without thousands separator</paragraph> 626*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3150318" xml-lang="en-US" l10n="U">C = currency format</paragraph> 627*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3153168" xml-lang="en-US" l10n="U">S = exponential representation, for example, 1.234+E56</paragraph> 628*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3153515" xml-lang="en-US" l10n="U">P = percentage</paragraph> 629*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3154375" xml-lang="en-US" l10n="U">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> 630*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3150575" xml-lang="en-US" l10n="U">D1 = MMM-D-YY, MM-D-YY and similar formats</paragraph> 631*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3150589" xml-lang="en-US" l10n="U">D2 = DD-MM</paragraph> 632*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3151034" xml-lang="en-US" l10n="U">D3 = MM-YY</paragraph> 633*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3156371" xml-lang="en-US" l10n="U">D4 = DD-MM-YYYY HH:MM:SS</paragraph> 634*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3157881" xml-lang="en-US" l10n="U">D5 = MM-DD</paragraph> 635*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3157894" xml-lang="en-US" l10n="U">D6 = HH:MM:SS AM/PM</paragraph> 636*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3154068" xml-lang="en-US" l10n="U">D7 = HH:MM AM/PM</paragraph> 637*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3150286" xml-lang="en-US" l10n="U">D8 = HH:MM:SS</paragraph> 638*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3145756" xml-lang="en-US" l10n="U">D9 = HH:MM</paragraph> 639*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3145768" xml-lang="en-US" l10n="U">G = All other formats</paragraph> 640*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3153375" xml-lang="en-US" l10n="U">- (Minus) at the end = negative numbers are formatted in color</paragraph> 641*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3155545" xml-lang="en-US" l10n="U">() (brackets) at the end = there is an opening bracket in the format code</paragraph> 642cdf0e10cSrcweir</tablecell> 643cdf0e10cSrcweir</tablerow> 644cdf0e10cSrcweir<tablerow> 645cdf0e10cSrcweir<tablecell> 646*666afc3eSmseidel<paragraph role="code" id="par_id3154594" xml-lang="en-US" l10n="U">COLOR</paragraph> 647cdf0e10cSrcweir</tablecell> 648cdf0e10cSrcweir<tablecell> 649*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3152922" xml-lang="en-US" l10n="U">Returns 1, if negative values have been formatted in color, otherwise 0.</paragraph> 650cdf0e10cSrcweir</tablecell> 651cdf0e10cSrcweir</tablerow> 652cdf0e10cSrcweir<tablerow> 653cdf0e10cSrcweir<tablecell> 654*666afc3eSmseidel<paragraph role="code" id="par_id3145563" xml-lang="en-US" l10n="U">PARENTHESES</paragraph> 655cdf0e10cSrcweir</tablecell> 656cdf0e10cSrcweir<tablecell> 657*666afc3eSmseidel<paragraph role="tablecontent" id="par_id3156072" xml-lang="en-US" l10n="U">Returns 1 if the format code contains an opening bracket (, otherwise 0.</paragraph> 658cdf0e10cSrcweir</tablecell> 659cdf0e10cSrcweir</tablerow> 660cdf0e10cSrcweir</table> 661*666afc3eSmseidel<paragraph role="paragraph" id="par_id3156090" xml-lang="en-US" l10n="U"><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> 662cdf0e10cSrcweir</section> 663cdf0e10cSrcweir</sort> 664cdf0e10cSrcweir<section id="relatedtopics"> 665cdf0e10cSrcweir<embed href="text/scalc/01/04060100.xhp#drking"/> 666cdf0e10cSrcweir</section> 667cdf0e10cSrcweir</body> 668cdf0e10cSrcweir</helpdocument> 669