Excel Spreadsheets Mathematical Functions (59)
There is a new function in Excel 2007 in this category.
Importance
Functions
What it Does
Interesting
SUM
Adds its arguments
Interesting
SUMPRODUCT
The most powerful and useful function in Excel
Interesting
ABS
Returns the absolute value of a number
Interesting
ROUND
Rounds a number to a specified number of digits
Interesting
ROUNDUP
Rounds a number up, away from zero
Interesting
SUBTOTAL
Returns a subtotal of a filtered list or database)
Interesting
TRUNC
Truncates a number to an integer
Interesting
MOD
Returns the remainder from division
Interesting
INT
Rounds a number down to the nearest integer)
Interesting
POWER
Returns the result of a number raised to a power
Interesting
SQRT
Returns a positive square root
Rarely Used
EVEN
Rounds a number up to the nearest even integer
Rarely Used
EXP
Returns e raised to the power of a given number
Rarely Used
FLOOR
Rounds a number down, toward zero
Rarely Used
ROUNDDOWN
Rounds a number down, toward zero
Rarely Used
GCD
Returns the greatest common divisor
Rarely Used
LCM
Returns the least common multiple
Rarely Used
ODD
Rounds a number up to the nearest odd integer
Rarely Used
MROUND
Returns a number rounded to the desired multiple
Rarely Used
PRODUCT
Multiplies its arguments
Rarely Used
QUOTIENT
Returns the integer portion of a division
Rarely Used
RAND
Returns a random number between 0 and 1
Rarely Used
RANDBETWEEN
Returns a random number between the numbers you specify
Rarely Used
ROMAN
Converts an arabic numeral to roman, as text
Rarely Used
SIGN
Returns the sign of a number
Rarely Used
CEILING
Rounds a number to the nearest integer or to the nearest multiple of significance
Rarely Used
COMBIN
Returns the number of combinations for a given number of objects
Rarely Used
ACOS
Returns the arccosine of a number
Rarely Used
ACOSH
Returns the inverse hyperbolic cosine of a number
Rarely Used
ASIN
Returns the arcsine of a number
Rarely Used
ASINH
Returns the inverse hyperbolic sine of a number
Rarely Used
ATAN
Returns the arctangent of a number
Rarely Used
ATAN2
Returns the arctangent from x- and y-coordinates
Rarely Used
ATANH
Returns the inverse hyperbolic tangent of a number
Rarely Used
COS
Returns the cosine of a number
Rarely Used
COSH
Returns the hyperbolic cosine of a number
Rarely Used
DEGREES
Converts radians to degrees
Rarely Used
FACT
Returns the factorial of a number
Rarely Used
LN
Returns the natural logarithm of a number
Rarely Used
LOG
Returns the logarithm of a number to a specified base
Rarely Used
LOG10
Returns the base-10 logarithm of a number
Rarely Used
MDETERM
Returns the matrix determinant of an array
Rarely Used
MINVERSE
Returns the matrix inverse of an array
Rarely Used
MMULT
Returns the matrix product of two arrays
Rarely Used
MULTINOMIA
Returns the multinomial of a set of numbers
Rarely Used
PI
Returns the value of pi
Rarely Used
RADIANS
Converts degrees to radians
Rarely Used
SERIESSUM
Returns the sum of a power series based on the formula
Rarely Used
SIN
Returns the sine of the given angle
Rarely Used
SINH
Returns the hyperbolic sine of a number
Rarely Used
SQRTPI
Returns the square root of (number * pi)
Rarely Used
SUMIF
Adds the cells specified by a given criteria (SUMPRODUCT does better)
Rarely Used
SUMSQ
Returns the sum of the squares of the arguments
Rarely Used
SUMX2MY2
Returns the sum of the difference of squares of corresponding values in two arrays
Rarely Used
SUMX2PY2
Returns the sum of the sum of squares of corresponding values in two arrays
Rarely Used
SUMXMY2
Returns the sum of squares of differences of corresponding values in two arrays
Rarely Used
TAN
Returns the tangent of a number
Rarely Used
TANH
Returns the hyperbolic tangent of a number
Rarely Used
FACTDOUBLE
Returns the double factorial of a number
In Excel 2007 and Up
Rarely Used
SUMIFS
Adds the cells specified by one or many given criteria(SUMPRODUCT does better)