Calc Guide

Syntax Description
COUNTBLANK(range)
Returns the number of empty cells. Range is the cell
range in which the empty cells are counted.
COUNTIF(range; criteria) Returns the number of elements that meet certain
criteria within a cell range. Range is the range to
which the criteria are to be applied. Criteria indicates
the criteria in the form of a number, a regular
expression, or a character string by which the cells are
counted.
DEGREES(number)
Converts the given number in radians to degrees.
EVEN(number)
Rounds the given number up to the nearest even
integer.
EXP(number)
Returns e raised to the power of the given number.
FACT(number)
Returns the factorial of the given number.
FLOOR(number;
significance; mode)
Rounds the given number down to the nearest multiple
of significance. Significance is the value to whose
multiple of ten the number is to be rounded down (.01, .
1, 1, 10, etc.). Mode is an optional value. If it is
indicated and non-zero and if the number and
significance are negative, rounding up is carried out
based on that value.
GCD(numbers) Returns the greatest common divisor of one or more
integers. Numbers is a list of up to 30 numbers whose
greatest common divisor is to be calculated, separated
by semi-colons.
GCD_ADD(numbers) Returns the greatest common divisor of a list of
numbers. Numbers is a list of up to 30 numbers
separated by semi-colons.
INT(number)
Rounds the given number down to the nearest integer.
ISEVEN(value)
Returns TRUE if the given value is an even integer, or
FALSE if the value is odd. If the value is not an
integer, the function evaluates only the integer part of
the value.
ISODD(value)
Returns TRUE if the given value is an odd integer, or
FALSE if the value is even. If the value is not an
integer, the function evaluates only the integer part of
the value.
LCM(integer_1;
integer_2; ... integer_30)
Returns the least common multiple of one or more
integers. Integer_1; integer_2;... integer_30 are
integers whose lowest common multiple is to be
calculated.
LCM_ADD(numbers)
Numbers is a list of up to 30 numbers separated by
semi-colons. The result is the lowest common multiple
of a list of numbers.
LN(number) Returns the natural logarithm based on the constant e
of the given number.
378 OpenOffice.org 3.3 Calc Guide