Calc Guide

Syntax Description
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.
Appendix B Description of Functions 465