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

Revision as of 16:11, 13 September 2008

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 106: / Line 106: @@
 '''(in [[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]])'''
-'''[[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]'''
+[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
+[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]