Difference between revisions of "Documentation/SL/How Tos/Calc: Matematične funkcije"
From Apache OpenOffice Wiki
< Documentation | SL/How Tos
(New page: ==Seznam matematičnih funkcij za Calc== {| border="0" cellpadding="0" cellspacing="10" align="left" |-valign="top" |colspan="2"|'''<big> Trigonometrične</big>''' |-valign="top" |[[Doc...) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
(6 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
+ | {{DISPLAYTITLE:Matematične funkcije}} | ||
==Seznam matematičnih funkcij za Calc== | ==Seznam matematičnih funkcij za Calc== | ||
Line 7: | Line 8: | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: COS | + | |[[Documentation/SL/How_Tos/Calc: funkcija COS|'''COS''']] |
|Returns the cosine of an angle. | |Returns the cosine of an angle. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: SIN | + | |[[Documentation/SL/How_Tos/Calc: funkcija SIN|'''SIN''']] |
|Returns the sine of an angle. | |Returns the sine of an angle. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: TAN | + | |[[Documentation/SL/How_Tos/Calc: funkcija TAN|'''TAN''']] |
|Returns the tangent of an angle. | |Returns the tangent of an angle. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: COT | + | |[[Documentation/SL/How_Tos/Calc: funkcija COT|'''COT''']] |
|Returns the cotangent of an angle. | |Returns the cotangent of an angle. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ACOS | + | |[[Documentation/SL/How_Tos/Calc: funkcija ACOS|'''ACOS''']] |
|Returns the inverse cosine of a number. | |Returns the inverse cosine of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ACOT | + | |[[Documentation/SL/How_Tos/Calc: funkcija ACOT|'''ACOT''']] |
|Returns the inverse cotangent of a number. | |Returns the inverse cotangent of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ASIN | + | |[[Documentation/SL/How_Tos/Calc: funkcija ASIN|'''ASIN''']] |
|Returns the inverse sine of a number. | |Returns the inverse sine of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ATAN | + | |[[Documentation/SL/How_Tos/Calc: funkcija ATAN|'''ATAN''']] |
|Returns the inverse tangent of a number. | |Returns the inverse tangent of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ATAN2 | + | |[[Documentation/SL/How_Tos/Calc: funkcija ATAN2|'''ATAN2''']] |
|Returns the inverse tangent for specified x and y coordinates. | |Returns the inverse tangent for specified x and y coordinates. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: DEGREES | + | |[[Documentation/SL/How_Tos/Calc: funkcija DEGREES|'''DEGREES''']] |
|Converts radians into degrees. | |Converts radians into degrees. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: RADIANS | + | |[[Documentation/SL/How_Tos/Calc: funkcija RADIANS|'''RADIANS''']] |
|Converts degrees into radians. | |Converts degrees into radians. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: PI | + | |[[Documentation/SL/How_Tos/Calc: funkcija PI|'''PI''']] |
|Returns the value of PI. | |Returns the value of PI. | ||
|-valign="top" | |-valign="top" | ||
− | |colspan="2"|'''<big> | + | |colspan="2"|'''<big> Hiperbolične</big>''' |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: COSH | + | |[[Documentation/SL/How_Tos/Calc: funkcija COSH|'''COSH''']] |
|Returns the hyperbolic cosine of an angle. | |Returns the hyperbolic cosine of an angle. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: SINH | + | |[[Documentation/SL/How_Tos/Calc: funkcija SINH|'''SINH''']] |
|Returns the hyperbolic sine of an angle. | |Returns the hyperbolic sine of an angle. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: TANH | + | |[[Documentation/SL/How_Tos/Calc: funkcija TANH|'''TANH''']] |
|Returns the hyperbolic tangent of an angle. | |Returns the hyperbolic tangent of an angle. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: COTH | + | |[[Documentation/SL/How_Tos/Calc: funkcija COTH|'''COTH''']] |
|Returns the hyperbolic cotangent of a given number (angle). | |Returns the hyperbolic cotangent of a given number (angle). | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ACOSH | + | |[[Documentation/SL/How_Tos/Calc: funkcija ACOSH|'''ACOSH''']] |
|Returns the inverse hyperbolic cosine of a number. | |Returns the inverse hyperbolic cosine of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ACOTH | + | |[[Documentation/SL/How_Tos/Calc: funkcija ACOTH|'''ACOTH''']] |
|Returns the inverse hyperbolic cotangent of the given number. | |Returns the inverse hyperbolic cotangent of the given number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ASINH | + | |[[Documentation/SL/How_Tos/Calc: funkcija ASINH|'''ASINH''']] |
|Returns the inverse hyperbolic sine of a number. | |Returns the inverse hyperbolic sine of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ATANH | + | |[[Documentation/SL/How_Tos/Calc: funkcija ATANH|'''ATANH''']] |
|Returns the inverse hyperbolic tangent of a number. | |Returns the inverse hyperbolic tangent of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |colspan="2"|'''<big> | + | |colspan="2"|'''<big> Zaokrožanje in ostanki</big>''' |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: TRUNC | + | |[[Documentation/SL/How_Tos/Calc: funkcija TRUNC|'''TRUNC''']] |
|Truncates a number by removing decimal places. | |Truncates a number by removing decimal places. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ROUND | + | |[[Documentation/SL/How_Tos/Calc: funkcija ROUND|'''ROUND''']] |
|Rounds a number to a certain precision. | |Rounds a number to a certain precision. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ROUNDDOWN | + | |[[Documentation/SL/How_Tos/Calc: funkcija ROUNDDOWN|'''ROUNDDOWN''']] |
|Rounds a number down, toward zero, to a certain precision. | |Rounds a number down, toward zero, to a certain precision. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ROUNDUP | + | |[[Documentation/SL/How_Tos/Calc: funkcija ROUNDUP|'''ROUNDUP''']] |
|Rounds a number up, away from zero, to a certain precision. | |Rounds a number up, away from zero, to a certain precision. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: CEILING | + | |[[Documentation/SL/How_Tos/Calc: funkcija CEILING|'''CEILING''']] |
|Returns a number rounded up to a multiple of another number. | |Returns a number rounded up to a multiple of another number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: FLOOR | + | |[[Documentation/SL/How_Tos/Calc: funkcija FLOOR|'''FLOOR''']] |
|Rounds a number down to the nearest multiple of another number. | |Rounds a number down to the nearest multiple of another number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: EVEN | + | |[[Documentation/SL/How_Tos/Calc: funkcija EVEN|'''EVEN''']] |
|Rounds a number to the next even integer away from zero. | |Rounds a number to the next even integer away from zero. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ODD | + | |[[Documentation/SL/How_Tos/Calc: funkcija ODD|'''ODD''']] |
|Rounds a number up to the next highest odd integer. | |Rounds a number up to the next highest odd integer. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: MROUND | + | |[[Documentation/SL/How_Tos/Calc: funkcija MROUND|'''MROUND''']] |
|Returns a number rounded to the nearest multiple of another number. | |Returns a number rounded to the nearest multiple of another number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: INT | + | |[[Documentation/SL/How_Tos/Calc: funkcija INT|'''INT''']] |
|Rounds a number down to the nearest integer. | |Rounds a number down to the nearest integer. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: QUOTIENT | + | |[[Documentation/SL/How_Tos/Calc: funkcija QUOTIENT|'''QUOTIENT''']] |
|Returns the integer result of a division operation. | |Returns the integer result of a division operation. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: MOD | + | |[[Documentation/SL/How_Tos/Calc: funkcija MOD|'''MOD''']] |
|Returns the remainder when one integer is divided by another. | |Returns the remainder when one integer is divided by another. | ||
|-valign="top" | |-valign="top" | ||
− | |colspan="2"|'''<big> | + | |colspan="2"|'''<big> Logaritemske / potenčne</big>''' |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: EXP | + | |[[Documentation/SL/How_Tos/Calc: funkcija EXP|'''EXP''']] |
|Returns e raised to the power of a number. | |Returns e raised to the power of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: POWER | + | |[[Documentation/SL/How_Tos/Calc: funkcija POWER|'''POWER''']] |
|Returns a number raised to a power. | |Returns a number raised to a power. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: LOG | + | |[[Documentation/SL/How_Tos/Calc: funkcija LOG|'''LOG''']] |
|Returns the natural logarithm of a number. | |Returns the natural logarithm of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: LN | + | |[[Documentation/SL/How_Tos/Calc: funkcija LN|'''LN''']] |
|Returns the logarithm of a number to the specified base. | |Returns the logarithm of a number to the specified base. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: LOG10 | + | |[[Documentation/SL/How_Tos/Calc: funkcija LOG10|'''LOG10''']] |
|Returns the base-10 logarithm of a number. | |Returns the base-10 logarithm of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |colspan="2"|'''<big> | + | |colspan="2"|'''<big> Besselove</big>''' |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: BESSELI | + | |[[Documentation/SL/How_Tos/Calc: funkcija BESSELI|'''BESSELI''']] |
− | |Calculates the modified Bessel | + | |Calculates the modified Bessel of the first kind. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: BESSELJ | + | |[[Documentation/SL/How_Tos/Calc: funkcija BESSELJ|'''BESSELJ''']] |
− | |Calculates the Bessel | + | |Calculates the Bessel of the first kind. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: BESSELK | + | |[[Documentation/SL/How_Tos/Calc: funkcija BESSELK|'''BESSELK''']] |
− | |Calculates the modified Bessel | + | |Calculates the modified Bessel of the second kind. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: BESSELY | + | |[[Documentation/SL/How_Tos/Calc: funkcija BESSELY|'''BESSELY''']] |
− | |Calculates the Bessel | + | |Calculates the Bessel of the second kind (the Neumann or Weber). |
|-valign="top" | |-valign="top" | ||
Line 186: | Line 187: | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ABS | + | |[[Documentation/SL/How_Tos/Calc: funkcija ABS|'''ABS''']] |
|Returns the absolute value of a number. | |Returns the absolute value of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: COMBIN | + | |[[Documentation/SL/How_Tos/Calc: funkcija COMBIN|'''COMBIN''']] |
|Returns the number of combinations of a subset of items. | |Returns the number of combinations of a subset of items. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: COMBINA | + | |[[Documentation/SL/How_Tos/Calc: funkcija COMBINA|'''COMBINA''']] |
|Returns the number of ordered combinations of a subset of items. | |Returns the number of ordered combinations of a subset of items. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: CONVERT | + | |[[Documentation/SL/How_Tos/Calc: funkcija CONVERT|'''CONVERT''']] |
|Converts between legacy European currencies and Euros. | |Converts between legacy European currencies and Euros. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: CONVERT_ADD | + | |[[Documentation/SL/How_Tos/Calc: funkcija CONVERT_ADD|'''CONVERT_ADD''']] |
|Converts a number from one measurement system to another. | |Converts a number from one measurement system to another. | ||
Line 214: | Line 215: | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: DELTA | + | |[[Documentation/SL/How_Tos/Calc: funkcija DELTA|'''DELTA''']] |
|Returns 1 if two numbers are equal, and 0 otherwise. | |Returns 1 if two numbers are equal, and 0 otherwise. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ERF | + | |[[Documentation/SL/How_Tos/Calc: funkcija ERF|'''ERF''']] |
− | |Calculates the error | + | |Calculates the error (Gauss error). |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ERFC | + | |[[Documentation/SL/How_Tos/Calc: funkcija ERFC|'''ERFC''']] |
− | |Calculates the complementary error | + | |Calculates the complementary error (complementary Gauss error). |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: FACT | + | |[[Documentation/SL/How_Tos/Calc: funkcija FACT|'''FACT''']] |
|Returns the factorial of a number, n!. | |Returns the factorial of a number, n!. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: FACTDOUBLE | + | |[[Documentation/SL/How_Tos/Calc: funkcija FACTDOUBLE|'''FACTDOUBLE''']] |
|Returns the double factorial of a number, n!!. | |Returns the double factorial of a number, n!!. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: GCD | + | |[[Documentation/SL/How_Tos/Calc: funkcija GCD|'''GCD''']] |
|Returns the greatest common divisor of two or more integers. | |Returns the greatest common divisor of two or more integers. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: GCD_ADD | + | |[[Documentation/SL/How_Tos/Calc: funkcija GCD_ADD|'''GCD_ADD''']] |
|Returns the greatest common divisor of a list of numbers. | |Returns the greatest common divisor of a list of numbers. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: GESTEP | + | |[[Documentation/SL/How_Tos/Calc: funkcija GESTEP|'''GESTEP''']] |
|Returns 1 if a number is greater than or equal to a step number, or 0 otherwise. | |Returns 1 if a number is greater than or equal to a step number, or 0 otherwise. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ISEVEN | + | |[[Documentation/SL/How_Tos/Calc: funkcija ISEVEN|'''ISEVEN''']] |
|Returns TRUE if the value is an even number. | |Returns TRUE if the value is an even number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ISODD | + | |[[Documentation/SL/How_Tos/Calc: funkcija ISODD|'''ISODD''']] |
|Returns TRUE if the value is an odd number. | |Returns TRUE if the value is an odd number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: LCM | + | |[[Documentation/SL/How_Tos/Calc: funkcija LCM|'''LCM''']] |
|Returns the least common multiple of one or more integers. | |Returns the least common multiple of one or more integers. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: LCM_ADD | + | |[[Documentation/SL/How_Tos/Calc: funkcija LCM_ADD|'''LCM_ADD''']] |
|Returns the lowest common multiple of a list of numbers. | |Returns the lowest common multiple of a list of numbers. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: MULTINOMIAL | + | |[[Documentation/SL/How_Tos/Calc: funkcija MULTINOMIAL|'''MULTINOMIAL''']] |
|Returns the factorial of the sum divided by the product of the factorials. | |Returns the factorial of the sum divided by the product of the factorials. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: PRODUCT | + | |[[Documentation/SL/How_Tos/Calc: funkcija PRODUCT|'''PRODUCT''']] |
|Multiplies all the numbers given as arguments and returns the product. | |Multiplies all the numbers given as arguments and returns the product. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: RAND | + | |[[Documentation/SL/How_Tos/Calc: funkcija RAND|'''RAND''']] |
|Returns a random number between 0 and 1. | |Returns a random number between 0 and 1. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: RANDBETWEEN | + | |[[Documentation/SL/How_Tos/Calc: funkcija RANDBETWEEN|'''RANDBETWEEN''']] |
|Returns an integer random number in a specified range. | |Returns an integer random number in a specified range. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: SERIESSUM | + | |[[Documentation/SL/How_Tos/Calc: funkcija SERIESSUM|'''SERIESSUM''']] |
|Sums the first terms of a power series. | |Sums the first terms of a power series. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: SIGN | + | |[[Documentation/SL/How_Tos/Calc: funkcija SIGN|'''SIGN''']] |
|Returns the sign of a number. | |Returns the sign of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: SQRT | + | |[[Documentation/SL/How_Tos/Calc: funkcija SQRT|'''SQRT''']] |
|Returns the positive square root of a number. | |Returns the positive square root of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: SQRTPI | + | |[[Documentation/SL/How_Tos/Calc: funkcija SQRTPI|'''SQRTPI''']] |
|Returns the square root of (PI times a number). | |Returns the square root of (PI times a number). | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/SL/How_Tos/Calc: funkcija SUBTOTAL|'''SUBTOTAL''']] | |[[Documentation/SL/How_Tos/Calc: funkcija SUBTOTAL|'''SUBTOTAL''']] | ||
− | | | + | |Vrne rezultate funkcij SUM, AVERAGE, STDDEV, itn. filtriranih podatkov. |
|-valign="top" | |-valign="top" | ||
Line 307: | Line 308: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/SL/How_Tos/Calc: funkcija SUMSQ|'''SUMSQ''']] | |[[Documentation/SL/How_Tos/Calc: funkcija SUMSQ|'''SUMSQ''']] | ||
− | | | + | |Vrne vsoto kvadratov števil. |
|} | |} | ||
Line 316: | Line 317: | ||
'''[[Documentation/SL/How_Tos/Calc: Funkcije po kategorijah|Funkcije po kategorijah]]''' | '''[[Documentation/SL/How_Tos/Calc: Funkcije po kategorijah|Funkcije po kategorijah]]''' | ||
+ | [[Category: SL/Documentation/Reference/Calc]] |
Latest revision as of 11:56, 24 November 2009
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. |