Page 264 - Excel Data Analysis

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

APPENDIX

EXCEL FUNCTION QUICK REFERENCE

(CONTINUED)

MATH & TRIG FUNCTIONS (CONTINUED)

FUNCTION DESCRIPTION
ODD(number) Rounds the number to the nearest odd integer.
PI() Returns the value of PI.
POWER(number, power) Raises the number to the specified power.
PRODUCT(number1, [number2, ...]) Multiplies the specified numbers.
QUOTIENT(numerator, denominator) Returns the integer result of division.
RADIANS(angle) Converts a radian measurement to degrees.
RAND() Creates a random number between 0 and 1.
RANDBETWEEN(bottom, top) AT Creates a random number between the specified values.
ROMAN(number, [form]) Creates a roman numeral.
ROUND(number, num_digits) Rounds a number to the specified number of digits.
ROUNDDOWN(number, num_digits) Rounds a number down to the specified number of digits.
ROUNDUP(number, num_digits) Rounds a number up to the specified number of digits.
SERIESSUM(x, n, m, coefficients) AT Sums a power series.
SIGN(number) Determines if a number is positive, negative, or zero.
SIN(number) Finds the sine of an angle.
SINH(number) Finds the hyperbolic sine.
SQRT(number) Determines the square root of a number.
SQRTPI(number) AT Determines the square root of a number multiplied by PI.
SUBTOTAL(function_num, ref1[, ref2,...]) Performs a subtotal function on a portion of a list.
SUM(number1, [number2, ...]) Sums the specified numbers.
SUMIF(range, criteria, [sum_range]) Sums the cells in the range that match the criteria.
SUMPRODUCT(array1[, array2, array3, ...]) Sums the products of the arrays.
SUMSQ(number1[, number2, ...]) Sums the squares of the values.

250