Documentation/How Tos/Calc: Information functions

From Apache OpenOffice Wiki
Jump to: navigation, search


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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_Information_functions&oldid=243237"
Views
Personal tools
Navigation
Print/export
Tools