# Quick Reference of Excel Math Functions in Office 365!!

Andrews Originally published at geekexcel.com on ・9 min read

## Math Functions in Excel:

In this article, we have tabulated the complete list of *Excel Math Functions in Office 365 * for your easy reference.

Excel Math functions comes in handy when you want to do the most common mathematical operations including sum, product, logarithm and even more in less time. If you want to know more math-related functions, you can refer the Excel Engineering Functions.

Click on a function name or read more columns in order to know the complete description of the function with examples.

Note: Excel version is specified in some functions that indicate the introduction of that particular function in Excel. For example, 2013 indicates that the function will be available in Excel 2013 and all the newest versions.

| S. No | Function | Explanation & Syntax | Read More |
| 1 | ABS Function | Returns the absolute value of a number.

``````=ABS(number)
``````

| 2 | AGGREGATE Function | Returns the result of the aggregate in a list or database of values.

Array Form:

``````=AGGREGATE(function\_num, options, array, [k])
``````

Reference Form:

``````=AGGREGATE(function\_num, options, ref1, [ref2], …)
``````

| 3 | ARABIC Function (2013) | Converts a Roman numeral into a number as Arabic numerals.

``````=ARABIC(roman\_text)
``````

| 4 | BASE Function (2013) | Converts a number into a text representation of a given radix or base.

``````=BASE(number, radix, [min\_length])
``````

| 5 | CEILING Function | Rounds a given number to the nearest specified multiple.

``````=CEILING(number, significance)
``````

| 6 | CEILING.MATH Function (2013) | Rounds the input number to the nearest integer or to the nearest multiple.

``````=CEILING.MATH(number, [significance], [mode])
``````

| 7 | CEILING.PRECISE Function | Rounds a number to the given multiple.

``````=CEILING.PRECISE(number, [significance])
``````

| 8 | DECIMAL Function (2013) | Converts an alpha-numeric number into a decimal value.

``````=DECIMAL(number, radix)
``````

| 9 | EVEN Function | Returns the even integer after rounding a given number up.

``````=EVEN(number)
``````

| 10 | EXP Function | Returns the value of a constant e raised to a number.

``````=EXP(number)
``````

| 11 | FACT Function | Returns the factorial of a given number.

``````=FACT(number)
``````

| 12 | FACTDOUBLE Function | Returns the double factorial of a given number.

``````=FACTDOUBLE(number)
``````

| 13 | FLOOR Function | Rounds a number down to the nearest multiple of significance.

``````=FLOOR(number, significance)
``````

| 14 | FLOOR.MATH Function (2013) | Rounds a given number to a specified multiple.

``````=FLOOR.MATH(number, [significance], [mode])
``````

| 15 | FLOOR.PRECISE Function | Rounds a given number to the specified multiple.

``````=FLOOR.PRECISE(number, [significance])
``````

| 16 | GCD Function | Returns the greatest common divisor of two or more integers.

``````=GCD(number1, [number2],…)
``````

| 17 | INT Function | Rounds a given integer number down to the nearest integer.

``````=INT(number)
``````

| 18 | LCM Function | Returns the least common multiple of the given integer value.

``````=LCM(number1, [number2],…)
``````

| 19 | LN Function | Returns the natural logarithm of a number.

``````=LN(number)
``````

| 20 | LOG Function | Returns the logarithm of a given number using the specified base.

``````=LOG(number,[base])
``````

| 21 | LOG10 Function | Returns the base10 logarithm of a given number.

``````=LOG10(number)
``````

| 22 | MDETERM Function | Returns the matrix determinant of a given array.

``````=MDETERM(array)
``````

| 23 | MINVERSE Function | Returns the inverse matrix of the given array.

``````=MINVERSE(array)
``````

| 24 | MOD Function | Returns the remainder of the two numbers after division.

``````=MOD(number, divisor)
``````

| 25 | MROUND Function | Returns a number rounded to the given multiple.

``````=MROUND(number, significance)
``````

| 26 | MUNIT Function (2013) | Returns the unit matrix for a given dimension.

``````=MUNIT(dimension))
``````

| 27 | ODD Function | Rounds a number to the nearest odd integer.

``````=ODD(number)
``````

| 28 | PI Function | Returns the value of the constant π (3.14159265358979).

``````=PI()
``````

| 29 | POWER Function | Returns a number that is raised to a given power.

``````=POWER(number, power)
``````

| 30 | PRODUCT Function | Returns the product of all the given input numbers.

``````=PRODUCT(number1, [number2], …)
``````

| 31 | QUOTIENT Function | Returns the integer portion of a division without the remainder.

``````=QUOTIENT(numerator, denominator)
``````

| 32 | RAND Function | Returns the random number between 0 and 1.

``````=RAND()
``````

| 33 | RANDBETWEEN Function | Returns the random integer number between the two specified values.

``````=RANDBETWEEN(bottom, top)
``````

| 34 | ROMAN Function | Converts a number to a Roman numeral as text.

``````=ROMAN(number, [form])
``````

| 35 | ROUND Function | Rounds a number to the specified number of digits.

``````=ROUND(number, num\_digits)
``````

| 36 | ROUNDDOWN Function | Rounds a number down to the specified number of digits towards zero.

``````=ROUNDDOWN(number, num\_digits)
``````

| 37 | ROUNDUP Function | Rounds a number up to the specified number of digits away from zero.

``````=ROUNDUP(number, num\_digits)
``````

| 38 | SIGN Function | Returns the sign of the given number.

``````=SIGN(number)
``````

| 39 | SQRT Function | Returns the square root of a positive integer.

``````=SQRT(number)
``````

| 40 | SUBTOTAL Function | Returns an aggregate result in a list or database.

``````=SUBTOTAL(function\_num, ref1, [ref2],...)
``````

| 41 | SUM Function | Adds values in the cells

``````=SUM(Number\_1,Number\_2,.....,Number\_255)
``````

| 42 | SUMIF Function | Returns the product of one or more complex numbers (1 – 255 complex numbers).

``````=IMPRODUCT(inumber, [inumber2],…)
``````

| 43 | SUMIFS Function | Returns the real coefficient of a complex number in the form of ( X+Yi ).

``````=IMREAL(inumber)
``````

| 44 | SUMPRODUCT Function | Multiplies the corresponding arrays or ranges and returns the sum of the products.

``````=SUMPRODUCT(array1, [array2], [array3], ...)
``````

| 45 | TRUNC Function | Returns a truncated number of a given value.

``````=TRUNC(number, [num\_digits])
``````

The above list of Math functions in Excel with its explanation and syntax assists you to know each function clearly. Don’t forget to share your valuable queries in the below section. Thanks for visiting Geek Excel!! Keep Learning with us!!

Posted on by:

### Andrews

Founder of Geek Excel!! Blog for Excel Tutorials