Difference between revisions of "Documentation/How Tos/Calc: Information functions"

Revision as of 04:34, 7 June 2013

CALC FUNCTIONS

Information Functions

< Previous Section

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.).

@@ Line 28: / Line 28: @@
 * [[Documentation/How_Tos/Calc:_NA_function|<div style="font-size: 120%;">Na]]
 * [[Documentation/How_Tos/Calc:_TYPE_function|<div style="font-size: 120%;">Type]]
-}}__TOC__
+}}__NOTOC__
 ==Information Functions==
 The information functions return information about cell contents.