Calc Guide

Syntax Description
ROUNDUP(number;
count)
Rounds the given number up. Count (optional)
is the number of digits to which rounding up is
to be done. If the count parameter is negative,
only the whole number portion is rounded. It is
rounded to the place indicated by the count.
SERIESSUM(x; n; m;
coefficients)
Returns a sum of powers of the number x in
accordance with the following formula:
SERIESSUM(x;n;m;coefficients) =
coefficient_1*x^n + coefficient_2*x^(n+m) +
coefficient_3*x^(n+2m) +...+
coefficient_i*x^(n+(i-1)m).
x is the number as an independent variable. n is
the starting power. m is the increment.
Coefficients is a series of coefficients. For each
coefficient the series sum is extended by one
section. You can only enter coefficients using
cell references.
SIGN(number)
Returns the sign of the given number. The
function returns the result 1 for a positive sign, –
1 for a negative sign, and 0 for zero.
SIN(number)
Returns the sine of the given number (angle in
radians).
SINH(number)
Returns the hyperbolic sine of the given number
(angle in radians).
SQRT(number) Returns the positive square root of the given
number. The value of the number must be
positive.
SQRTPI(number) Returns the square root of the product of the
given number and PI.
SUBTOTAL(function;
range)
Calculates subtotals. If a range already contains
subtotals, these are not used for further
calculations. Function is a value that stands for
another function such as Average, Count, Min,
Sum, Var. Range is the range whose cells are
included.
SUM(number_1;
number_2; ...
number_30)
Adds all the numbers in a range of cells.
Number_1; number_2;... number_30 are up to
30 arguments whose sum is to be calculated. You
can also enter a range using cell references.
SUMIF(range; criteria;
sum_range)
Adds the cells specified by a given criteria. The
search supports regular expressions. Range is
434 OpenOffice.org 3.x Calc Guide