Appendix H: Excel Spreadsheets  Mathematical Functions (58)

This web page is an appendix. For more see Excel Mathematical formulas in lesson 3-14

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

 
                 
       

 

Developed and Presented by PLI Consultant Inc