Excel Spreadsheets Functions: Mathematical

6137494695 
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 ycoordinates 
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 base10 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 
Discover Even More in 50 Excel spreadsheets 

6137494695 
Tips and Ideas on Excel 
Tips and Ideas on Macros 
Excel Spreadsheets Functions: Mathematical