Contents

Know more about this
(or any other) subject?

Show off your know-how at Quamut Wiki.

Learn more with these titles from Barnes & Noble

Learn Excel 2007 from Mr. Excel

Microsoft Office Excel 2007 Step by Step

Beginning Pivot Tables in Excel 2007: From Novice to Professional

Microsoft Office Excel 2007 QuickSteps

2007 Microsoft Office System Inside Out

Previous:
Date and Time Functions

Next:
Statistical Functions

Math and Trigonometry Functions

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

Acknowledgments & Disclaimer

Previous:
Date and Time Functions

Next:
Statistical Functions

Download & Print this Quamut to Go

Complete 8-page Quamut to Go PDF only $2.95

Add Quamut to cart

What's a Quamut?