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

Revision as of 05:47, 7 June 2013

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 1: / Line 1: @@
 {{Documentation/MasterTOC
 |bookid=1234'''
-|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
+|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">[[Documentation/Reference/Calc_functions|CALC FUNCTIONS]]</div>
 |ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Information_functions|<div style="font-size: 140%;">Information Functions]]
 |ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_CELL_function