Now we’ve taken a look at some of the basic functions in Excel, you should have got an idea for how they work. For the more adventurous or mathematically minded among you – here’s a more compreshensive list of mathematical functions and what they do.
If you’re not a mathematician you might want to have a dictionary handy for most of these, or skip to the next section!
ABS
Gives the absolute value of a number
ACOS
Gives the arccosine of a number
ACOSH
Gives the inverse hyperbolic cosine of a number
ASIN
Gives the arcsine of a number
ASINH
Gives the inverse hyperbolic sine of a number
ATAN
Gives the arctangent of a number
ATAN2
Gives the arctangent from x- and y-coordinates
ATANH
Gives the inverse hyperbolic tangent of a number
CEILING
Rounds a number to the nearest integer or to the nearest multiple of significance
COMBIN
Gives the number of combinations for a given number of objects
COS
Gives the cosine of a number
COSH
Gives the hyperbolic cosine of a number
DEGREES
Converts radians to degrees
EVEN
Rounds a number up to the nearest even integer
EXP
Gives e raised to the power of a given number
FACT
Gives the factorial of a number
FACTDOUBLE
Gives the double factorial of a number
FLOOR
Rounds a number down, toward zero
GCD
Gives the greatest common divisor
INT
Rounds a number down to the nearest integer
LCM
Gives the least common multiple
LN
Gives the natural logarithm of a number
LOG
Gives the logarithm of a number to a specified base
LOG10
Gives the base-10 logarithm of a number
MDETERM
Gives the matrix determinant of an array
MINVERSE
Gives the matrix inverse of an array
MMULT
Gives the matrix product of two arrays
MOD
Gives the remainder from division
MROUND
Gives a number rounded to the desired multiple
MULTINOMIAL
Gives the multinomial of a set of numbers
ODD
Rounds a number up to the nearest odd integer
PI
Gives the value of pi
POWER
Gives the result of a number raised to a power
PRODUCT
Multiplies its arguments
QUOTIENT
Gives the integer portion of a division
RADIANS
Converts degrees to radians
RAND
Gives a random number between 0 and 1
RANDBETWEEN
Gives a random number between the numbers you specify
ROMAN
Converts an arabic numeral to roman, as text
ROUND
Rounds a number to a specified number of digits
ROUNDDOWN
Rounds a number down, toward zero
ROUNDUP
Rounds a number up, away from zero
SERIESSUM
Gives the sum of a power series based on the formula
SIGN
Gives the sign of a number
SIN
Gives the sine of the given angle
SINH
Gives the hyperbolic sine of a number
SQRT
Gives a positive square root
SQRTPI
Gives the square root of (number * pi)
SUBTOTAL
Gives a subtotal in a list or database
SUM
Adds together its arguments
SUMIF
Adds the cells specified by a given criteria
SUMPRODUCT
Gives the sum of the products of corresponding array components
SUMSQ
Gives the sum of the squares of the arguments
SUMX2MY2
Gives the sum of the difference of squares of corresponding values in two arrays
SUMX2PY2
Gives the sum of the sum of squares of corresponding values in two arrays
SUMXMY2
Gives the sum of squares of differences of corresponding values in two arrays
TAN
Gives the tangent of a number
TANH
Gives the hyperbolic tangent of a number
TRUNC
Number truncated to an integer
