Calc Guide

Syntax Description
function. x is the value on which the function
will be calculated. n is the order of the
Bessel function.
BIN2DEC(number) Returns the decimal number for the binary
number entered. Number is the binary
number.
BIN2HEX(number; places) Returns the hexadecimal number for the
binary number entered. Number is the
binary number. Places is the number of
places to be output.
BIN2OCT(number; places) Returns the octal number for the binary
number entered. Number is the binary
number. Places is the number of places to be
output.
COMPLEX(real_num; i_num;
suffix)
Returns a complex number from a real
coefficient and an imaginary coefficient.
Real_num is the real coefficient of the
complex number. I_num is the imaginary
coefficient of the complex number. Suffix is
list of options, "i” or "j”.
CONVERT_ADD(number;
from_unit; to_unit)
Converts a value from one unit of measure to
the corresponding value in another unit of
measure. Number is the number to be
converted. From_unit is the unit from which
conversion is taking place. To_unit is the
unit to which conversion is taking place.
DEC2BIN(number; places) Returns the binary number for the decimal
number entered between –512 and 511.
Number is the decimal number. Places is
the number of places to be output.
DEC2HEX(number; places) Returns the hexadecimal number for the
decimal number entered. Number is the
decimal number. Places is the number of
places to be output.
DEC2OCT(number; places) Returns the octal number for the decimal
number entered. Number is the decimal
number. Places is the number of places to
be output.
DELTA(number_1;
number_2)
Returns TRUE (1) if both numbers are
equal, otherwise returns FALSE (0).
480 OpenOffice.org 3.x Calc Guide