Excel - Math Functions

Quiz

The Excel math functions perform many of the common mathematical calculations, including basic arithmetic, conditional sums and products, exponents and logarithms, etc.

Some more math-related functions are also discussed in the statistical functions and engineering functions categories.

Math Functions

The following table lists all the Math functions −

S.No.	Function and Description
1	ABS Returns the absolute value of a number
2	AGGREGATE Returns an aggregate in a list or database
3	ARABIC Converts a Roman number to Arabic, as a number
4	BASE Converts a number into a text representation with the given radix (base)
5	CEILING.MATH Rounds a number up, to the nearest integer or to the nearest multiple of significance
6	COMBIN Returns the number of combinations for a given number of objects
7	COMBINA Returns the number of combinations with repetitions for a given number of items
8	DECIMAL Converts a text representation of a number in a given base into a decimal number
9	DEGREES Converts radians to degrees
10	EVEN Rounds a number up to the nearest even integer
11	EXP Returns e raised to the power of a given number
12	FACT Returns the factorial of a number
13	FACTDOUBLE Returns the double factorial of a number
14	FLOOR.MATH Rounds a number down, to the nearest integer or to the nearest multiple of significance
15	GCD Returns the greatest common divisor
16	INT Rounds a number down to the nearest integer
17	LCM Returns the least common multiple
18	LN Returns the natural logarithm of a number
19	LOG Returns the logarithm of a number to a specified base
20	LOG10 Returns the base-10 logarithm of a number
21	MDETERM Returns the matrix determinant of an array
22	MINVERSE Returns the matrix inverse of an array
23	MMULT Returns the matrix product of two arrays
24	MOD Returns the remainder from division
25	MROUND Returns a number rounded to the desired multiple
26	MULTINOMIAL Returns the multinomial of a set of numbers
27	MUNIT Returns the unit matrix or the specified dimension
28	ODD Rounds a number up to the nearest odd integer
29	PI Returns the value of pi
30	POWER Returns the result of a number raised to a power
31	PRODUCT Multiplies its arguments
32	QUOTIENT Returns the integer portion of a division
33	RADIANS Converts degrees to radians
34	RAND Returns a random number between 0 and 1
35	RANDBETWEEN Returns a random number between the numbers that you specify
36	ROMAN Converts an Arabic numeral to Roman, as text
37	ROUND Rounds a number to a specified number of digits
38	ROUNDDOWN Rounds a number down, toward 0
39	ROUNDUP Rounds a number up, away from 0
40	SERIESSUM Returns the sum of a power series based on the formula
41	SIGN Returns the sign of a number
42	SQRT Returns a positive square root
43	SQRTPI Returns the square root of pi
44	SUBTOTAL Returns a subtotal in a list or database
45	SUM Adds its arguments
46	SUMIF Adds the cells specified by a given criteria
47	SUMIFS Adds the cells specified by a multiple criteria
48	SUMPRODUCT Returns the sum of the products of corresponding array components
49	SUMSQ Returns the sum of the squares of the arguments
50	SUMX2MY2 Returns the sum of the difference of squares of corresponding values in two arrays
51	SUMX2PY2 Returns the sum of the sum of squares of corresponding values in two arrays
52	SUMXMY2 Returns the sum of squares of differences of corresponding values in two arrays
53	TRUNC Truncates a number (you specify the precision of the truncation)

Print Page