Math and Trigonometry Functions

Back

ABS : Returns the absolute value of a number
ACOS : Returns the arccosine of a number
ACOSH : Returns the inverse hyperbolic cosine of a number
ASIN : Returns the arcsine of a number
ASINH : Returns the inverse hyperbolic sine of a number
ATAN : Returns the arctangent of a number
ATAN2 : Returns the arctangent from x- and y-coordinates
ATANH : Returns the inverse hyperbolic tangent of a number
CEILING : Rounds a number to the nearest integer or to the nearest multiple of significance
COMBIN : Returns the number of combinations for a given number of objects
COS : Returns the cosine of a number
COSH : Returns the hyperbolic cosine of a number
DEGREES : Converts radians to degrees
EVEN : Rounds a number up to the nearest even integer
EXP : Returns e raised to the power of a given number
FACT : Returns the factorial of a number
FACTDOUBLE : Returns the double factorial of a number
FLOOR : Rounds a number down, toward zero
GCD : Returns the greatest common divisor
INT : Rounds a number down to the nearest integer
LCM : Returns the least common multiple
LN : Returns the natural logarithm of a number
LOG : Returns the logarithm of a number to a specified base
LOG10 : Returns the base-10 logarithm of a number
MDETERM : Returns the matrix determinant of an array
MINVERSE : Returns the matrix inverse of an array
MMULT : Returns the matrix product of two arrays
MOD : Returns the remainder from division
MROUND : Returns a number rounded to the desired multiple
MULTINOMIAL : Returns the multinomial of a set of numbers
ODD : Rounds a number up to the nearest odd integer
PI : Returns the value of pi
POWER : Returns the result of a number raised to a power
PRODUCT : Multiplies its arguments
QUOTIENT : Returns the integer portion of a division
RADIANS : Converts degrees to radians
RAND : Returns a random number between 0 and 1
RANDBETWEEN : Returns a random number between the numbers you specify
ROMAN : Converts an arabic numeral to roman, as text
ROUND : Rounds a number to a specified number of digits
ROUNDDOWN : Rounds a number down, toward zero
ROUNDUP : Rounds a number up, away from zero
SERIESSUM : Returns the sum of a power series based on the formula
SIGN : Returns the sign of a number
SIN : Returns the sine of the given angle
SINH : Returns the hyperbolic sine of a number
SQRT : Returns a positive square root
SQRTPI : Returns the square root of (number * pi)
SUBTOTAL : Returns a subtotal in a list or database
SUM : Adds its arguments
SUMIF : Adds the cells specified by a given criteria
SUMPRODUCT : Returns the sum of the products of corresponding array components
SUMSQ : Returns the sum of the squares of the arguments
SUMX2MY2 : Returns the sum of the difference of squares of corresponding values in two arrays
SUMX2PY2 : Returns the sum of the sum of squares of corresponding values in two arrays
SUMXMY2 : Returns the sum of squares of differences of corresponding values in two arrays
TAN : Returns the tangent of a number
TANH : Returns the hyperbolic tangent of a number
TRUNC : Truncates a number to an integer