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 el cotangente de un angulo.
ACOS	Regresa el cotangente inverso de un numero.
ACOT	Regresa la cotangente inversa de un numero.
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	Convierte radianes en grados.
RADIANS	Converts degrees into radians.
PI	Regresa el valor de PI.
Hyperbolic
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.
Rounding and remainders
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