Calc Guide

Syntax Description
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.
406 OpenOffice.org 3.3 Calc Guide