OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 380)

Syntax Description

ROUNDDOWN(number;

count)

Rounds the given number. Count (optional) is the

number of digits to be rounded down to. If the count

parameter is negative, only the whole number portion

is rounded. It is rounded to the place indicated by the

count.

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 the range to

which the criteria are to be applied. Criteria is the cell

in which the search criterion is shown, or the search

criterion itself. Sum_range is the range from which

values are summed; if it has not been indicated, the

values found in the Range are summed.

380 OpenOffice.org 3.3 Calc Guide

1 2 ... 375 376 377 378 379 380 381 382 383 384 385 ... 433 434

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 380

Comentarios a estos manuales

Relacionado con productos y manuales para Software OpenOffice.org OpenOffice - 3.3