OpenOffice.org OpenOffice - 3.3 Základní průvodce stáhnout pdf (Strana 379)

Syntax Description

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.

MULTINOMIAL

(number(s))

Returns the factorial of the sum of the arguments

divided by the product of the factorials of the

arguments. Number(s) is a list of up to 30 numbers

separated by semi-colons.

ODD(number)

Rounds the given number up to the nearest odd

integer.

PI() Returns the value of PI to fourteen decimal places.

POWER(base; power)

Returns the result of a number raised to a power. Base

is the number that is to be raised to the given power.

Power is the exponent by which the base is to be

raised.

PRODUCT(number 1 to 30) Multiplies all the numbers given as arguments and

returns the product. Number 1 to number 30 are up

to 30 arguments whose product is to be calculated,

separated by semi-colons.

QUOTIENT(numerator;

denominator)

Returns the integer result of a division operation.

Numerator is the number that will be divided.

Denominator is the number the numerator will be

divided by.

RADIANS(number)

Converts the given number in degrees to radians.

RAND() Returns a random number between 0 and 1. This

number will recalculate every time data is entered or

F9 is pressed.

RANDBETWEEN (bottom;

top)

Returns an integer random number between bottom

and top (inclusive). This number will recalculate when

the Control+Shift+F9 key combination is pressed.

ROUND(number; count)

Rounds the given number to a certain number of

decimal places according to valid mathematical

criteria. Count (optional) is the number of the places to

which the value is to be rounded. If the count

parameter is negative, only the whole number portion

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

count.

Appendix B Description of Functions 379

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

Komentáře k této Příručce

Žádné komentáře

OpenOffice.org OpenOffice - 3.3 Základní průvodce Strana 379

Komentáře k této Příručce

Související produkty a manuály pro Software OpenOffice.org OpenOffice - 3.3