OOoES/Traduccion/Calc: Funciones Matematicas

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.
Logarithm / powers
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).
Miscellaneous
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.

See also

Functions listed by category