Skip to content

Math and Trigonometry Functions

ABS Returns the absolute value of a number.
ACOS Returns the arccosine of a number in radians in the range 0 to pi.
ACOSH Returns the inverse hyperbolic cosine of a number.
ASIN Returns the arcsine of a number in radians in the range -pi/2 to pi/2.
ASINH Returns the inverse hyperbolic sine of a number.
ATAN Returns the arctangent of a number in radians in the range -pi/2 to pi/2
ATAN2 Returns the four-quadrant arctangent of the specified x- and y- coordinates in radians between -pi and pi excluding -pi. A positive result represents a counterclockwise angle from the x-axis, a negative result represents a clockwise angle.
ATANH Returns the inverse hyperbolic tangent of a number.
CEILING Returns a number rounded up, away from zero, to the nearest multiple of significance.
COMBIN Returns the number of combinations for a given number of items.
COS Returns the cosine of the given angle.
COSH Returns the hyperbolic cosine of a number.
DEGREES Converts radians into degrees.
EVEN Returns a number rounded up to the next even integer for positive integers and rounded down to the next even integer for negative numbers.
EXP Returns e (2.71828182845804) raised to the power of a specified number.
FACT Returns the factorial of a number.
FLOOR Returns a number rounded down, toward zero, to the nearest multiple of significance.
INT Rounds a number down to the nearest integer.
LN Returns the natural (base e) logarithm of a number.
LOG Returns the logarithm of a number of the base you specify.
LOG10 Returns the base-10 logarithm of a number.
MDETERM Returns the matrix determinant of an array.
MINVERSE Returns the inverse matrix for the matrix stored in an array.
MMULT Returns the matrix product of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2.
MOD Returns the remainder of a division operation (modulus).
ODD Returns a number rounded up away from zero to the nearest odd integer.
PI Returns the approximate number 3.14159265358979, the mathematical constant pi, accurate to 15 digits.
POWER Returns the result of a specified number raised to a specified power.
PRODUCT Multiplies all the numbers given as arguments and returns the product.
RADIANS Converts degrees to radians.
RAND Returns an evenly distributed random number greater than or equal to 0 and less than 1. A new random number is returned every time the worksheet is calculated.
ROMAN Converts an Arabic numeral to Roman, as text.
ROUND Round a number to a specified number of digits.
ROUNDDOWN Rounds a number down, towards zero.
ROUNDUP Rounds a number up, away from zero.
SIGN Determines the sign of a number. Returns 1 if the value is positive, 0 if the value is 0, and -1 if the value is negative.
SIN Returns the sine of a given angle.
SINH Returns the hyperbolic sine of a number.
SQRT Returns a positive square root.
SUM Adds all the numbers in a range of cells.
SUMIF Adds the cells specified by a certain criteria.
SUMPRODUCT Multiplies corresponding components in the given arrays, and returns the sum of those products.
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 the given angle.
TANH Returns the hyperbolic tangent of a number.
TRUNC Truncates a number to an integer by removing the fractional part of a number.