Calc Guide

Syntax Description
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.
LOG(number; base)
Returns the logarithm of the given number to
the specified base. Base is the base for the
logarithm calculation.
LOG10(number) Returns the base-10 logarithm of the given
number.
MOD(dividend; divisor) Returns the remainder after a number is divided
by a divisor. Dividend is the number which will
be divided by the divisor. Divisor is the number
by which to divide the dividend.
MROUND(number;
multiple)
The result is the nearest integer multiple of the
number.
432 OpenOffice.org 3.x Calc Guide