| Functions |
What it Does |
| SUM |
Adds its arguments |
|
SUMPRODUCT |
The most powerful
and useful function in Excel |
| ROUND |
Rounds a number to a specified
number of digits |
| ROUNDUP |
Rounds a number up, away from
zero |
| SUBTOTAL |
Returns a subtotal of a filtered list or
database) |
| TRUNC |
Truncates a number to an integer |
| INT |
Rounds a number down to the
nearest integer) |
| ABS |
Returns the absolute value of a
number |
| MOD |
Returns the remainder from
division |
| POWER |
Returns the result of a number
raised to a power |
| SQRT |
Returns a positive square root |
| EVEN |
Rounds a number up to the
nearest even integer |
| EXP |
Returns
e raised to the power of a given number |
| FLOOR |
Rounds a number down, toward
zero |
| ROUNDDOWN |
Rounds a number down, toward
zero |
| GCD |
Returns the greatest common
divisor |
| LCM |
Returns
the least common multiple |
| ODD |
Rounds a number up to the
nearest odd integer |
| MROUND |
Returns a number rounded to the
desired multiple |
| PRODUCT |
Multiplies its arguments |
| QUOTIENT |
Returns the integer portion of a
division |
| 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 |
| SIGN |
Returns the sign 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 |
| 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 |
| COS |
Returns the cosine of a number |
| COSH |
Returns the hyperbolic cosine of
a number |
| DEGREES |
Converts radians to degrees |
| FACT |
Returns the factorial of a
number |
| 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 |
| MULTINOMIA |
Returns the multinomial of a set
of numbers |
| PI |
Returns the value of pi |
| RADIANS |
Converts degrees to radians |
| SERIESSUM |
Returns the sum of a power
series based on the formula |
| SIN |
Returns the sine of the given
angle |
| SINH |
Returns the hyperbolic sine of a
number |
| SQRTPI |
Returns the square root of
(number * pi) |
| SUMIF |
Adds the cells specified by a
given criteria |
| 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 |
| FACTDOUBLE |
Returns the double factorial of
a number |
| In Excel 2007 and Up |
| SUMIFS |
Adds the cells specified by
one or many given criteria
(SUMPRODUCT does better) |
Back home