Calc Guide

Mathematical functions
Table 34: Mathematical functions
Syntax Description
ABS(number)
Returns the absolute value of the given number.
ACOS(number)
Returns the inverse cosine of the given number
in radians.
ACOSH(number) Returns the inverse hyperbolic cosine of the
given number in radians.
ACOT(number) Returns the inverse cotangent of the given
number in radians.
ACOTH(number) Returns the inverse hyperbolic cotangent of the
given number in radians.
ASIN(number)
Returns the inverse sine of the given number in
radians.
ASINH(number) Returns the inverse hyperbolic sine of the given
number in radians.
ATAN(number) Returns the inverse tangent of the given
number in radians.
ATAN2(number_x;
number_y)
Returns the inverse tangent of the specified x
and y coordinates. Number_x is the value for the
x coordinate. Number_y is the value for the y
coordinate.
ATANH(number) Returns the inverse hyperbolic tangent of the
given number. (Angle is returned in radians.)
CEILING(number;
significance; mode)
Rounds the given number to the nearest integer
or multiple of significance. Significance is the
value to whose multiple of ten the value is to be
rounded up (.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.
COMBIN(count_1;
count_2)
Returns the number of combinations for a given
number of objects. Count_1 is the total number
of elements. Count_2 is the selected count from
the elements. This is the same as the nCr
function on a calculator.
430 OpenOffice.org 3.x Calc Guide