Informational Functions

Apache OpenOffice 4.1 Calc Guide

Appendix B — Description of Functions

< Previous Section

Next Section >

• Functions Available in Calc
  • Terminology: Numbers and Arguments
• Mathematical Functions
• Financial Analysis Functions
  • A Note About Dates
  • A Note About Interest Rates
• Statistical Analysis Functions
• Date and Time Functions
• Logical Functions
• Informational Functions
• Database Functions
• Array Functions
• Spreadsheet Functions
• Text Functions
• Converting Decimal, Binary, Octal, Hexadecimal
• Complex Number Functions

< Previous Page

Next Page >

Informational Functions

These functions provide information (or feedback) regarding the results of a test for a specific condition, or a test for the type of data or content a cell contains.

Table 42: Informational functions

Syntax	Description
CELL(info_type; reference)	Returns information on a cell, such as its address, formatting, or contents, based on the value of the info_type argument. Info_type specifies the type of information to be returned and comes from a predefined list of arguments. Info_type is not case sensitive, but it must be enclosed within quotes. Reference is the address of the cell to be examined. If reference is a range, the cell reference moves to the top left of the range. If reference is missing, Calc uses the position of the cell in which this formula is located.
CURRENT()	Calculates the current value of a formula at the actual position within the formula.
FORMULA(reference)	Displays the formula of a formula cell determined by reference. The formula will be returned as a string. If reference is not a formula cell, or if the presented argument is not a reference, returns the error value #N/A.
ISBLANK(value)	Returns TRUE if the reference to a cell is blank. This function is used to determine if the content of a cell is empty. A cell with a formula inside is not empty. Value is the cell to be tested.
ISERR(value)	Returns TRUE if the value refers to any error value except #N/A. You can use this function to control error values in certain cells. If an error occurs, the function returns TRUE. Value is any value or expression in which a test is performed to determine whether an error value, not equal to #N/A, is present.
ISERROR(value)	ISERROR tests if the cells contain general error values. ISERROR recognizes the #N/A error value. If an error occurs, the function returns TRUE. Value is any value where a test is performed to determine whether it is an error value.
ISEVEN_ADD(number)	Tests for even numbers. Returns TRUE (1) if the number returns a whole number when divided by 2.
ISFORMULA(reference)	Returns TRUE if a cell is a formula cell. Reference indicates the reference to a cell to test.
ISLOGICAL(value)	Returns TRUE if the cell contains a logical number format. The function is used to check for both TRUE and FALSE values in certain cells. Value is the cell to be tested for logical number format.
ISNA(value)	Returns TRUE if a cell contains the #N/A (value not available) error value. Value is the value or expression to be tested.
ISNONTEXT(value)	Tests if the cell contents are text or numbers, and returns FALSE if the contents are text. Value is any value or expression where a test is performed to determine whether it is a text, or numbers, or a Boolean value.
ISNUMBER(value)	Returns TRUE if the value refers to a number. Value is any expression to be tested to determine whether it is a number or text.
ISODD_ADD(number)	Returns TRUE (1) if the number does not return a whole number when divided by 2. Number is the number to be tested.
ISREF(value)	Tests if the content of a cell is a reference. Value is the value to be tested, to determine whether it is a reference.
ISTEXT(value)	Returns TRUE if the cell contents refer to text. Value is a value, a number, a Boolean value, or an error value to be tested.
N(value)	Returns the numeric value of its argument. Text, FALSE, and #N/A have a value of zero. Value is the parameter to be converted into a number.
NA()	Returns the error value #N/A.
TYPE(value)	Returns the type of value. Value is a specific value for which the data type is determined. The returned values are: 1 = number, 2 = text, 4 = Boolean value, 8 = formula, 16 = error value.