Matematične funkcije
From Apache OpenOffice Wiki
< Documentation | SL/How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Seznam matematičnih funkcij za Calc
Trigonometrične | |
COS | Returns the cosine of an angle. |
SIN | Returns the sine of an angle. |
TAN | Returns the tangent of an angle. |
COT | Returns the cotangent of an angle. |
ACOS | Returns the inverse cosine of a number. |
ACOT | Returns the inverse cotangent of a number. |
ASIN | Returns the inverse sine of a number. |
ATAN | Returns the inverse tangent of a number. |
ATAN2 | Returns the inverse tangent for specified x and y coordinates. |
DEGREES | Converts radians into degrees. |
RADIANS | Converts degrees into radians. |
PI | Returns the value of PI. |
Hiperbolične | |
COSH | Returns the hyperbolic cosine of an angle. |
SINH | Returns the hyperbolic sine of an angle. |
TANH | Returns the hyperbolic tangent of an angle. |
COTH | Returns the hyperbolic cotangent of a given number (angle). |
ACOSH | Returns the inverse hyperbolic cosine of a number. |
ACOTH | Returns the inverse hyperbolic cotangent of the given number. |
ASINH | Returns the inverse hyperbolic sine of a number. |
ATANH | Returns the inverse hyperbolic tangent of a number. |
Zaokrožanje in ostanki | |
TRUNC | Truncates a number by removing decimal places. |
ROUND | Rounds a number to a certain precision. |
ROUNDDOWN | Rounds a number down, toward zero, to a certain precision. |
ROUNDUP | Rounds a number up, away from zero, to a certain precision. |
CEILING | Returns a number rounded up to a multiple of another number. |
FLOOR | Rounds a number down to the nearest multiple of another number. |
EVEN | Rounds a number to the next even integer away from zero. |
ODD | Rounds a number up to the next highest odd integer. |
MROUND | Returns a number rounded to the nearest multiple of another number. |
INT | Rounds a number down to the nearest integer. |
QUOTIENT | Returns the integer result of a division operation. |
MOD | Returns the remainder when one integer is divided by another. |
Logaritemske / potenčne | |
EXP | Returns e raised to the power of a number. |
POWER | Returns a number raised to a power. |
LOG | Returns the natural logarithm of a number. |
LN | Returns the logarithm of a number to the specified base. |
LOG10 | Returns the base-10 logarithm of a number. |
Besselove | |
BESSELI | Calculates the modified Bessel of the first kind. |
BESSELJ | Calculates the Bessel of the first kind. |
BESSELK | Calculates the modified Bessel of the second kind. |
BESSELY | Calculates the Bessel of the second kind (the Neumann or Weber). |
Razne | |
ABS | Returns the absolute value of a number. |
COMBIN | Returns the number of combinations of a subset of items. |
COMBINA | Returns the number of ordered combinations of a subset of items. |
CONVERT | Converts between legacy European currencies and Euros. |
CONVERT_ADD | Converts a number from one measurement system to another. |
COUNTBLANK | Vrne število praznih celic. |
COUNTIF | Prešteje celice v danem obsegu, ki ustrezajo navedenemu pogoju. |
DELTA | Returns 1 if two numbers are equal, and 0 otherwise. |
ERF | Calculates the error (Gauss error). |
ERFC | Calculates the complementary error (complementary Gauss error). |
FACT | Returns the factorial of a number, n!. |
FACTDOUBLE | Returns the double factorial of a number, n!!. |
GCD | Returns the greatest common divisor of two or more integers. |
GCD_ADD | Returns the greatest common divisor of a list of numbers. |
GESTEP | Returns 1 if a number is greater than or equal to a step number, or 0 otherwise. |
ISEVEN | Returns TRUE if the value is an even number. |
ISODD | Returns TRUE if the value is an odd number. |
LCM | Returns the least common multiple of one or more integers. |
LCM_ADD | Returns the lowest common multiple of a list of numbers. |
MULTINOMIAL | Returns the factorial of the sum divided by the product of the factorials. |
PRODUCT | Multiplies all the numbers given as arguments and returns the product. |
RAND | Returns a random number between 0 and 1. |
RANDBETWEEN | Returns an integer random number in a specified range. |
SERIESSUM | Sums the first terms of a power series. |
SIGN | Returns the sign of a number. |
SQRT | Returns the positive square root of a number. |
SQRTPI | Returns the square root of (PI times a number). |
SUBTOTAL | Vrne rezultate funkcij SUM, AVERAGE, STDDEV, itn. filtriranih podatkov. |
SUM | Sešteje vsebino celic. |
SUMIF | Pogojno sešteje vsebino celic v obsegu. |
SUMSQ | Vrne vsoto kvadratov števil. |