Math and trigonometry functions (reference)

Click one of the links in the following list to see detailed help about the function.

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