Math and Trigonometry functions

Microsoft Office Excel 2003

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