Difference between revisions of "Documentation/How Tos/Calc: Information functions"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
 
(15 intermediate revisions by 7 users not shown)
Line 1: Line 1:
−
==Informacijske funkcije==
+
{{DISPLAYTITLE:Information functions}}
 +
{{Documentation/CalcFunc InformationTOC
 +
|ShowPrevPage={{{ShowPrevPage}}}
 +
|PrevPage={{{PrevPage}}}
 +
|ShowNextPage={{{ShowNextPage}}}
 +
|NextPage={{{NextPage}}}
 +
|bookid=CalcFunctions
 +
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">[[Documentation/Reference/Calc_functions|CALC FUNCTIONS]]</div>
 +
|ShowParttitle=block
 +
|parttitle=[[Documentation/How_Tos/Calc:_Information_functions|<div style="font-size: 140%;">Information Functions]]
 +
|ShowPrevPart=block
 +
|PrevPart=Documentation/How_Tos/Calc:_Financial_functions
 +
|ShowNextPart=block
 +
|NextPart=Documentation/How_Tos/Calc:_Logical_functions
 +
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
 +
}}__NOTOC__
 +
 
 +
[[File:open.jpg]]
 +
 
 +
==<big>Information Functions</big>==
 
The information functions return information about cell contents.  
 
The information functions return information about cell contents.  
  
 
{| border="0" cellpadding="0" cellspacing="10" align="left"
 
{| border="0" cellpadding="0" cellspacing="10" align="left"
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija CELL|'''CELL''']]
+
|[[Documentation/How_Tos/Calc: CELL function|'''CELL''']]
 
|Returns information about the address, formatting or contents of a cell
 
|Returns information about the address, formatting or contents of a cell
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija CURRENT|'''CURRENT''']]
+
|[[Documentation/How_Tos/Calc: CURRENT function|'''CURRENT''']]
 
|Returns the current (to date) result of evaluating the formula.
 
|Returns the current (to date) result of evaluating the formula.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija FORMULA|'''FORMULA''']]
+
|[[Documentation/How_Tos/Calc: FORMULA function|'''FORMULA''']]
 
|Returns the formula used in a cell as a text string.
 
|Returns the formula used in a cell as a text string.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija ISBLANK|'''ISBLANK''']]
+
|[[Documentation/How_Tos/Calc: ISBLANK function|'''ISBLANK''']]
 
|Tests if the cell is blank (empty).
 
|Tests if the cell is blank (empty).
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija ISERR|'''ISERR''']]
+
|[[Documentation/How_Tos/Calc: ISERR function|'''ISERR''']]
 
|Tests for an error value other than '''#N/A''' (Not Available).
 
|Tests for an error value other than '''#N/A''' (Not Available).
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija ISERROR|'''ISERROR''']]
+
|[[Documentation/How_Tos/Calc: ISERROR function|'''ISERROR''']]
 
|Tests for any error value.
 
|Tests for any error value.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija ISEVEN|'''ISEVEN''']]
+
|[[Documentation/How_Tos/Calc: ISEVEN function|'''ISEVEN''']]
 
|Tests for even numbers.
 
|Tests for even numbers.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija ISEVEN_ADD|'''ISEVEN_ADD''']]
+
|[[Documentation/How_Tos/Calc: ISEVEN_ADD function|'''ISEVEN_ADD''']]
 
|Returns 1 if the value is an even number, or 0 if the value is odd.
 
|Returns 1 if the value is an even number, or 0 if the value is odd.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija ISFORMULA|'''ISFORMULA''']]
+
|[[Documentation/How_Tos/Calc: ISFORMULA function|'''ISFORMULA''']]
 
|Tests if a cell contains a formula.
 
|Tests if a cell contains a formula.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija ISLOGICAL|'''ISLOGICAL''']]
+
|[[Documentation/How_Tos/Calc: ISLOGICAL function|'''ISLOGICAL''']]
 
|Tests if a cell contains a logical value, '''TRUE''' or '''FALSE'''.
 
|Tests if a cell contains a logical value, '''TRUE''' or '''FALSE'''.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija ISNA|'''ISNA''']]
+
|[[Documentation/How_Tos/Calc: ISNA function|'''ISNA''']]
 
|Tests if a cell contains the '''#N/A''' (Not Available) error value.  
 
|Tests if a cell contains the '''#N/A''' (Not Available) error value.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija ISNONTEXT|'''ISNONTEXT''']]
+
|[[Documentation/How_Tos/Calc: ISNONTEXT function|'''ISNONTEXT''']]
 
|Tests if a cell contains non-text.
 
|Tests if a cell contains non-text.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija ISNUMBER|'''ISNUMBER''']]
+
|[[Documentation/How_Tos/Calc: ISNUMBER function|'''ISNUMBER''']]
 
|Tests if a cell contains a number.
 
|Tests if a cell contains a number.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija ISODD|'''ISODD''']]
+
|[[Documentation/How_Tos/Calc: ISODD function|'''ISODD''']]
 
|Tests for odd numbers.
 
|Tests for odd numbers.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija ISODD_ADD|'''ISODD_ADD''']]
+
|[[Documentation/How_Tos/Calc: ISODD_ADD function|'''ISODD_ADD''']]
 
|Returns 1 if the value is an odd number, or 0 if the value is even.
 
|Returns 1 if the value is an odd number, or 0 if the value is even.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija ISREF|'''ISREF''']]
+
|[[Documentation/How_Tos/Calc: ISREF function|'''ISREF''']]
 
|Tests if the argument is a reference to a cell or range of cells.
 
|Tests if the argument is a reference to a cell or range of cells.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija ISTEXT|'''ISTEXT''']]
+
|[[Documentation/How_Tos/Calc: ISTEXT function|'''ISTEXT''']]
 
|Tests if a cell contains text.
 
|Tests if a cell contains text.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija N|'''N''']]
+
|[[Documentation/How_Tos/Calc: N function|'''N''']]
 
|Returns the numeric value.
 
|Returns the numeric value.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija NA|'''NA''']]
+
|[[Documentation/How_Tos/Calc: NA function|'''NA''']]
 
|Returns the '''#N/A''' (Not Available) error value .
 
|Returns the '''#N/A''' (Not Available) error value .
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/SL/How_Tos/Calc: funkcija TYPE|'''TYPE''']]
+
|[[Documentation/How_Tos/Calc: TYPE function|'''TYPE''']]
 
|Returns the type of value (number, text, etc.).
 
|Returns the type of value (number, text, etc.).
  
Line 87: Line 106:
 
<!-- why on earth is this necessary? -->
 
<!-- why on earth is this necessary? -->
  
−
==Glejte tudi==
+
{{SeeAlso|EN|
−
'''[[Documentation/SL/How_Tos/Calc: funkcija AREAS|AREAS]]''',
+
* [[Documentation/How_Tos/Calc: AREAS function|AREAS]], [[Documentation/How_Tos/Calc: COLUMN function|COLUMN]], [[Documentation/How_Tos/Calc: COLUMNS function|COLUMNS]], [[Documentation/How_Tos/Calc: ERRORTYPE function|ERRORTYPE]], [[Documentation/How_Tos/Calc: INFO function|INFO]], [[Documentation/How_Tos/Calc: ROW function|ROW]], [[Documentation/How_Tos/Calc: ROWS function|ROWS]], [[Documentation/How_Tos/Calc: SHEET function|SHEET]], [[Documentation/How_Tos/Calc: SHEETS function|SHEETS]]
−
'''[[Documentation/SL/How_Tos/Calc: funkcija COLUMN|COLUMN]]''',
+
:: (in [[Documentation/How_Tos/Calc: Spreadsheet functions|Spreadsheet functions]])
−
'''[[Documentation/SL/How_Tos/Calc: funkcija COLUMNS|COLUMNS]]''',
+
 
−
'''[[Documentation/SL/How_Tos/Calc: funkcija ERRORTYPE|ERRORTYPE]]''',
+
* [[Documentation/How_Tos/Calc: ISLEAPYEAR function|ISLEAPYEAR]]
−
'''[[Documentation/SL/How_Tos/Calc: funkcija INFO|INFO]]''',
+
:: (in [[Documentation/How_Tos/Calc: Date & Time functions|Date & Time functions]])
−
'''[[Documentation/SL/How_Tos/Calc: funkcija ROW|ROW]]''',
+
−
'''[[Documentation/SL/How_Tos/Calc: funkcija ROWS|ROWS]]''',
+
−
'''[[Documentation/SL/How_Tos/Calc: funkcija SHEET|SHEET]]''',
+
−
'''[[Documentation/SL/How_Tos/Calc: funkcija SHEETS|SHEETS]]'''
+
−
'''(in [[Documentation/SL/How_Tos/Calc: Funkcije za preglednice|Funkcije za preglednice]])'''
+
  
−
'''[[Documentation/SL/How_Tos/Calc: funkcija DELTA|DELTA]]''',
+
* [[Documentation/How_Tos/Calc: DELTA function|DELTA]], [[Documentation/How_Tos/Calc: GESTEP function|GESTEP]]
−
'''[[Documentation/SL/How_Tos/Calc: funkcija GESTEP|GESTEP]]'''
+
:: (in [[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]])
−
'''(in [[Documentation/SL/How_Tos/Calc: Matematične funkcije|Matematične funkcije]])'''
+
  
−
'''[[Documentation/SL/How_Tos/Calc: Funkcije po kategorijah|Funkcije po kategorijah]]'''
+
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 +
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]
 +
}}
 +
[[Category: Documentation/Reference/Calc]]

Latest revision as of 16:18, 1 February 2024

Information Functions
[[{{{PrevPage}}}|< Previous Page

]]

[[{{{NextPage}}}|Next Page 
>]]
Open.jpg

Information Functions

The information functions return information about cell contents.

CELL Returns information about the address, formatting or contents of a cell
CURRENT Returns the current (to date) result of evaluating the formula.
FORMULA Returns the formula used in a cell as a text string.
ISBLANK Tests if the cell is blank (empty).
ISERR Tests for an error value other than #N/A (Not Available).
ISERROR Tests for any error value.
ISEVEN Tests for even numbers.
ISEVEN_ADD Returns 1 if the value is an even number, or 0 if the value is odd.
ISFORMULA Tests if a cell contains a formula.
ISLOGICAL Tests if a cell contains a logical value, TRUE or FALSE.
ISNA Tests if a cell contains the #N/A (Not Available) error value.
ISNONTEXT Tests if a cell contains non-text.
ISNUMBER Tests if a cell contains a number.
ISODD Tests for odd numbers.
ISODD_ADD Returns 1 if the value is an odd number, or 0 if the value is even.
ISREF Tests if the argument is a reference to a cell or range of cells.
ISTEXT Tests if a cell contains text.
N Returns the numeric value.
NA Returns the #N/A (Not Available) error value .
TYPE Returns the type of value (number, text, etc.).



See Also
(in Spreadsheet functions)
(in Date & Time functions)
(in Mathematical functions)
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_Information_functions&oldid=259960"
Views
Personal tools
Navigation
Tools
In other languages