Page 263 - Excel Data Analysis

14 537547 AppB.qxd 3/4/03 11:57 AM Page 249

EXCEL FUNCTION QUICK REFERENCE B

MATH & TRIG FUNCTIONS

FUNCTION DESCRIPTION
ABS(number) Finds the absolute value of a number.
ACOS(number) Finds the arccosine of a number.
ACOSH(number) Finds the inverse hyperbolic cosine.
ASIN(number) Finds the arcsine of a number.
ASINH(number) Finds the inverse hyperbolic sine.
ATAN(number) Finds the arctangent of a number.
ATAN2(x_num, y_num) Finds the arctangent using two coordinates of an angle.
ATANH(number) Finds the inverse hyperbolic tangent.
CIELING(number, significance) Rounds a number up to a specific multiple.
COMBIN(number, number_chosen) Finds the number of unique combinations for the specified
number of items.
COS(number) Finds the cosine of an angle.
COSH(number) Finds the hyperbolic cosine.
DEGREES(angle) Converts a number from radians to degrees.
EVEN(number) Rounds the number to the nearest even integer.
EXP(number) Raises the constant to the power of the specified number.
FACT(number) Finds the factorial of the number.
FLOOR(number, significance) Rounds a number down to a specific multiple.
GCD(number1, [number2, ...]) AT Finds the greatest common divisor for the specified numbers.
INT(number) Rounds a number to the nearest integer.
LCM(number1, [number2, ...]) AT Finds the least common multiple.
LN(number) Finds the natural logarithm of the specified number.
LOG(number, [base]) Finds the logarithm of a number to the specified base.
LOG10(number) Finds the logarithm of a number to base-10.
MDETERM(array) Finds the determinant of an array.
MINVERSE(array) Finds the inverse of a square matrix.
MMULT(array1, array2) Determines the product of two matrixes.
MOD(number, divisor) Finds the remainder of the division.
MROUND(number, multiple) AT Rounds a number to the specified integer multiple.
MULTINOMIAL(number1, [number2, ...]) AT Divides the sum by the product of factorials.

249