Difference between revisions of "Documentation/How Tos/Calc: Information functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also) |
(→See also) |
||
| Line 87: | Line 87: | ||
<!-- why on earth is this necessary? --> | <!-- why on earth is this necessary? --> | ||
| − | + | {{Documentation/SeeAlso| | |
| − | + | * [[Documentation/How_Tos/Calc: AREAS function|AREAS]], [[Documentation/How_Tos/Calc: COLUMN function|COLUMN]], [[Documentation/How_Tos/Calc: COLUMNS function|COLUMNS]], [[Documentation/How_Tos/Calc: ERRORTYPE function|ERRORTYPE]], [[Documentation/How_Tos/Calc: INFO function|INFO]], [[Documentation/How_Tos/Calc: ROW function|ROW]], [[Documentation/How_Tos/Calc: ROWS function|ROWS]], [[Documentation/How_Tos/Calc: SHEET function|SHEET]], [[Documentation/How_Tos/Calc: SHEETS function|SHEETS]]<br> (in [[Documentation/How_Tos/Calc: Spreadsheet functions|Spreadsheet functions]]) | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | * [[Documentation/How_Tos/Calc: ISLEAPYEAR function|ISLEAPYEAR]] <br> (in [[Documentation/How_Tos/Calc: Date & Time functions|Date & Time functions]]) | |
| − | + | ||
| − | + | * [[Documentation/How_Tos/Calc: DELTA function|DELTA]], [[Documentation/How_Tos/Calc: GESTEP function|GESTEP]] <br> (in [[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]) | |
| − | + | ||
| − | + | ||
| − | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]], |
| − | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]] |
| + | }} | ||
Revision as of 09:17, 3 March 2009
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.). |
