Documentation/How Tos/Calc: Information functions

From Apache OpenOffice Wiki
Jump to: navigation, search

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)

Funkcije po kategorijah

Personal tools