Math and trigonometry functions (reference)
Click one of the links in the following list to see detailed help about the function.
Function 
Description 
Returns the absolute value of a number 

Returns the arccosine of a number 

Returns the inverse hyperbolic cosine of a number 

Returns the arcsine of a number 

Returns the inverse hyperbolic sine of a number 

Returns the arctangent of a number 

Returns the arctangent from x and ycoordinates 

Returns the inverse hyperbolic tangent of a number 

Rounds a number to the nearest integer or to the nearest multiple of significance 

Returns the number of combinations for a given number of objects 

Returns the cosine of a number 

Returns the hyperbolic cosine of a number 

Converts radians to degrees 

Rounds a number up to the nearest even integer 

Returns e raised to the power of a given number 

Returns the factorial of a number 

Returns the double factorial of a number 

Rounds a number down, toward zero 

Returns the greatest common divisor 

Rounds a number down to the nearest integer 

Returns the least common multiple 

Returns the natural logarithm of a number 

Returns the logarithm of a number to a specified base 

Returns the base10 logarithm of a number 

Returns the matrix determinant of an array 

Returns the matrix inverse of an array 

Returns the matrix product of two arrays 

Returns the remainder from division 

Returns a number rounded to the desired multiple 

Returns the multinomial of a set of numbers 

Rounds a number up to the nearest odd integer 

Returns the value of pi 

Returns the result of a number raised to a power 

Multiplies its arguments 

Returns the integer portion of a division 

Converts degrees to radians 

Returns a random number between 0 and 1 

Returns a random number between the numbers you specify 

Converts an arabic numeral to roman, as text 

Rounds a number to a specified number of digits 

Rounds a number down, toward zero 

Rounds a number up, away from zero 

Returns the sum of a power series based on the formula 

Returns the sign of a number 

Returns the sine of the given angle 

Returns the hyperbolic sine of a number 

Returns a positive square root 

Returns the square root of (number * pi) 

Returns a subtotal in a list or database 

Adds its arguments 

Adds the cells specified by a given criteria 

Adds the cells in a range that meet multiple criteria 

Returns the sum of the products of corresponding array components 

Returns the sum of the squares of the arguments 

Returns the sum of the difference of squares of corresponding values in two arrays 

Returns the sum of the sum of squares of corresponding values in two arrays 

Returns the sum of squares of differences of corresponding values in two arrays 

Returns the tangent of a number 

Returns the hyperbolic tangent of a number 

Truncates a number to an integer 