Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

OpenOffice Calc User Guide
Previous Page Home 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 16: Informational functions

Syntax

Description

CELL(info_type; reference)

Returns information on a cell such as its address, formatting or contents of a cell 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.

FORMULA(reference)

Displays the formula of a formula cell at any position. The formula will be returned as a string in the Reference position. If no formula cell can be found, 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. If an error occurs, the function returns a logical or numerical value. Value is the content 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 a logical or numerical value. 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)

The ISERROR tests if the cells contain general error values. ISERROR recognizes the #N/A error value. If an error occurs, the function returns a logical or numerical value. 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. If an error occurs, the function returns a logical or numerical value. Reference indicates the reference to a cell in which a test will be performed to determine if it contains a reference.

ISLOGICAL(value)

Returns TRUE if the cell contains a logical number format. The function is used in order to check for both TRUE and FALSE values in certain cells. If an error occurs, the function returns a logical or numerical value. Value is the value to be tested for logical number format.

ISNA(value)

Returns TRUE if a cell contains the #N/A (value not available) error value. If an error occurs, the function returns a logical or numerical 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. If an error occurs, the function returns a logical or numerical value. 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. If an error occurs, the function returns a logical or numerical value. 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 one or several cells is a reference. Verifies the type of references in a cell or a range of cells. If an error occurs, the function returns a logical or numerical value. 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. If an error occurs, the function returns a logical or numerical value. Value is a value, number, Boolean value, or error value to be tested.

N(value)

Returns the number 1, if the parameter is TRUE. Returns the parameter, if the parameter is a number. Returns the number 0 for other parameters. If an error occurs, the function returns a logical or numerical value. Value is the parameter to be converted into a number.

NA()

Returns the error value #N/A.

TYPE(value)

Returns the type of value. If an error occurs, the function returns a logical or numerical value. Value is a specific value for which the data type is determined. Value 1 = number, value 2 = text, value 4 = Boolean value, value 8 = formula, value 16 = error value.

OpenOffice Calc User Guide
Previous Page Home Next Page

 
 
  Published under the terms of the Open Publication License Design by Interspire