Calc Guide

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 40: 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.
Appendix B Description of Functions 405