Information functions
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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
