Difference between revisions of "Documentation/SL/How Tos/Calc: Informacijske funkcije"
From Apache OpenOffice Wiki
< Documentation | SL/How Tos
OOoWikiBot (Talk | contribs) m (Bot: Adding Category: Documentation) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
Line 104: | Line 104: | ||
'''[[Documentation/SL/How_Tos/Calc: Funkcije po kategorijah|Funkcije po kategorijah]]''' | '''[[Documentation/SL/How_Tos/Calc: Funkcije po kategorijah|Funkcije po kategorijah]]''' | ||
− | [[Category: Documentation]] | + | [[Category: SL/Documentation/Reference/Calc]] |
Latest revision as of 11:56, 24 November 2009
Informacijske funkcije
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.). |
Glejte tudi
AREAS, COLUMN, COLUMNS, ERRORTYPE, INFO, ROW, ROWS, SHEET, SHEETS (in Funkcije za preglednice)
DELTA, GESTEP (in Matematične funkcije)