613-749-4695
[email protected]
Excel Spreadsheets Functions: Mathematical
|
|
613-749-4695 |
|
Tips and Ideas on Excel |
Tips and Ideas on Macros |
|
This page is offered to you as reference See Excel Math & Trig formulas in chapter 20 |
Excel Lesson 24H of 24: Excel Spreadsheets Mathematical Functions (58)Here is the list of the functions of the math & trig category. Of the 58 functions of the math & trig category 11 are interesting and useful. Follow the links below to discover formulas using them. |
||
| 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 |
| Specialized | ACOS | Returns the arccosine of a number |
| Specialized | ACOSH | Returns the inverse hyperbolic cosine of a number |
| Specialized | ASIN | Returns the arcsine of a number |
| Specialized | ASINH | Returns the inverse hyperbolic sine of a number |
| Specialized | ATAN | Returns the arctangent of a number |
| Specialized | ATAN2 | Returns the arctangent from x- and y-coordinates |
| Specialized | ATANH | Returns the inverse hyperbolic tangent of a number |
| Specialized | COS | Returns the cosine of a number |
| Specialized | COSH | Returns the hyperbolic cosine of a number |
| Specialized | DEGREES | Converts radians to degrees |
| Specialized | FACT | Returns the factorial of a number |
| Specialized | LN | Returns the natural logarithm of a number |
| Specialized | LOG | Returns the logarithm of a number to a specified base |
| Specialized | LOG10 | Returns the base-10 logarithm of a number |
| Specialized | MDETERM | Returns the matrix determinant of an array |
| Specialized | MINVERSE | Returns the matrix inverse of an array |
| Specialized | MMULT | Returns the matrix product of two arrays |
| Specialized | MULTINOMIA | Returns the multinomial of a set of numbers |
| Specialized | PI | Returns the value of pi |
| Specialized | RADIANS | Converts degrees to radians |
| Specialized | SERIESSUM | Returns the sum of a power series based on the formula |
| Specialized | SIN | Returns the sine of the given angle |
| Specialized | SINH | Returns the hyperbolic sine of a number |
| Specialized | SQRTPI | Returns the square root of (number * pi) |
| Obsolete | SUMIF | Adds the cells specified by a given criteria (See why it is rarely used) |
| Specialized | SUMSQ | Returns the sum of the squares of the arguments |
| Specialized | SUMX2MY2 | Returns the sum of the difference of squares of corresponding values in two arrays |
| Specialized | SUMX2PY2 | Returns the sum of the sum of squares of corresponding values in two arrays |
| Specialized | SUMXMY2 | Returns the sum of squares of differences of corresponding values in two arrays |
| Specialized | TAN | Returns the tangent of a number |
| Specialized | TANH | Returns the hyperbolic tangent of a number |
|
Next Chapter: Statistical Functions in Excel |
Excel Table of Contents |
|
|
|
|
613-749-4695 |
|
Tips and Ideas on Excel |
Tips and Ideas on Macros |
Excel Spreadsheets Functions: Mathematical
Discover Even More in