Calc Guide

Syntax Description
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.
464 OpenOffice.org 3.x Calc Guide