Difference between revisions of "OOoES/Traduccion/Calc: Funciones Matematicas"
From Apache OpenOffice Wiki
< OOoES
Line 141: | Line 141: | ||
|-valign="top" | |-valign="top" | ||
− | |colspan="2"|'''<big> | + | |colspan="2"|'''<big> Logaritmos / potencias</big>''' |
|-valign="top" | |-valign="top" | ||
Line 183: | Line 183: | ||
|-valign="top" | |-valign="top" | ||
− | |colspan="2"|'''<big> | + | |colspan="2"|'''<big>Varios</big>''' |
|-valign="top" | |-valign="top" | ||
Line 313: | Line 313: | ||
<!-- why on earth is this necessary? --> | <!-- why on earth is this necessary? --> | ||
− | == | + | ==Ver tambien== |
'''[[OOoES/Traduccion/Calc: Funcion Functions listed by category|Functions listed by category]]''' | '''[[OOoES/Traduccion/Calc: Funcion Functions listed by category|Functions listed by category]]''' |
Revision as of 20:46, 13 April 2008
Lista de funciones matematicas
Trigonometricos | |
COS | Regresa el coseno de un angulo. |
SIN | Regresa el seno de un angulo. |
TAN | Regresa el tangente de un angulo. |
COT | Regresa la cotangente de un angulo. |
ACOS | Regresa la cotangente inverso de un numero. |
ACOT | Regresa la cotangente inversa de un numero. |
ASIN | Regresa el seno inverso de un numero. |
ATAN | Regresa la tangente inversa de un numero. |
ATAN2 | Reresa la tangente inversa de las coordenadas especificadas entre x y y. |
DEGREES | Convierte radianes en grados. |
RADIANS | Convierte grados en radianes. |
PI | Regresa el valor de PI. |
Hyperbole | |
COSH | Devuelve el coseno hiperbolico de un angulo |
SINH | Devuelve el seno hiperbolico de un angulo. |
TANH | Devuelve la tangente hiperbolica de un angulo. |
COTH | Devuelve la cotangente hiperbolica dado por un numero (angulo). |
ACOSH | Devuelve la coseno inverso de la hiperbola de un numero. |
ACOTH | Devuelve la cotangenta inversa de la hiperbola de un numero. |
ASINH | Devuelve el seno inverso hyperbole de un numero. |
ATANH | Devuelve la tangente inversa hyperbole de un numero. |
Redondeos y sobrantes | |
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. |
Logaritmos / potencias | |
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. |
Bessels | |
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). |
Varios | |
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 | Returns the number of empty cells. |
COUNTIF | Counts the number of cells in a range that meet a specified condition. |
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. |
RAIZ | Regresa el valor positivo de la raiz cuadrada. |
SQRTPI | Returns the square root of (PI times a number). |
SUBTOTAL | Returns SUM, AVERAGE, STDDEV, etc. results for filtered data. |
SUMA | Suma el contenido de las celdas. |
SUMA.SI | Conditionally sums the contents of cells in a range. |
SUMSQ | Regresa la suma de los numero de cuadros. |