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

From Apache OpenOffice Wiki
Jump to: navigation, search
(Undo revision 87446 by Filmsi (Talk))
Line 1: Line 1:
−
==Informacijske funkcije==
+
==Information Functions==
 
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 87:
 
<!-- why on earth is this necessary? -->
 
<!-- why on earth is this necessary? -->
  
−
==Glejte tudi==
+
==See also==
−
'''[[Documentation/SL/How_Tos/Calc: funkcija AREAS|AREAS]]''',
+
'''[[Documentation/How_Tos/Calc: AREAS function|AREAS]]''',
−
'''[[Documentation/SL/How_Tos/Calc: funkcija COLUMN|COLUMN]]''',
+
'''[[Documentation/How_Tos/Calc: COLUMN function|COLUMN]]''',
−
'''[[Documentation/SL/How_Tos/Calc: funkcija COLUMNS|COLUMNS]]''',
+
'''[[Documentation/How_Tos/Calc: COLUMNS function|COLUMNS]]''',
−
'''[[Documentation/SL/How_Tos/Calc: funkcija ERRORTYPE|ERRORTYPE]]''',
+
'''[[Documentation/How_Tos/Calc: ERRORTYPE function|ERRORTYPE]]''',
−
'''[[Documentation/SL/How_Tos/Calc: funkcija INFO|INFO]]''',
+
'''[[Documentation/How_Tos/Calc: INFO function|INFO]]''',
−
'''[[Documentation/SL/How_Tos/Calc: funkcija ROW|ROW]]''',
+
'''[[Documentation/How_Tos/Calc: ROW function|ROW]]''',
−
'''[[Documentation/SL/How_Tos/Calc: funkcija ROWS|ROWS]]''',
+
'''[[Documentation/How_Tos/Calc: ROWS function|ROWS]]''',
−
'''[[Documentation/SL/How_Tos/Calc: funkcija SHEET|SHEET]]''',
+
'''[[Documentation/How_Tos/Calc: SHEET function|SHEET]]''',
−
'''[[Documentation/SL/How_Tos/Calc: funkcija SHEETS|SHEETS]]'''
+
'''[[Documentation/How_Tos/Calc: SHEETS function|SHEETS]]'''
−
'''(in [[Documentation/SL/How_Tos/Calc: Funkcije za preglednice|Funkcije za preglednice]])'''
+
'''(in [[Documentation/How_Tos/Calc: Spreadsheet functions|Spreadsheet functions]])'''
  
−
'''[[Documentation/SL/How_Tos/Calc: funkcija DELTA|DELTA]]''',
+
'''[[Documentation/How_Tos/Calc: DELTA function|DELTA]]''',
−
'''[[Documentation/SL/How_Tos/Calc: funkcija GESTEP|GESTEP]]'''
+
'''[[Documentation/How_Tos/Calc: GESTEP function|GESTEP]]'''
−
'''(in [[Documentation/SL/How_Tos/Calc: Matematične funkcije|Matematične funkcije]])'''
+
'''(in [[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]])'''
  
−
'''[[Documentation/SL/How_Tos/Calc: Funkcije po kategorijah|Funkcije po kategorijah]]'''
+
'''[[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]'''

Revision as of 20:00, 20 July 2008

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

AREAS, COLUMN, COLUMNS, ERRORTYPE, INFO, ROW, ROWS, SHEET, SHEETS (in Spreadsheet functions)

DELTA, GESTEP (in Mathematical functions)

Functions listed by category

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_Information_functions&oldid=87447"
Personal tools