DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Quick Reference of Excel Math Functions in Office 365!!

#excelfunctions #mathfunctionsinexcel #excel #excel365tutorials

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)
Enter fullscreen mode Exit fullscreen mode

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

Array Form:

=AGGREGATE(function\_num, options, array, [k])
Enter fullscreen mode Exit fullscreen mode

Reference Form:

=AGGREGATE(function\_num, options, ref1, [ref2], …)
Enter fullscreen mode Exit fullscreen mode

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

=ARABIC(roman\_text)
Enter fullscreen mode Exit fullscreen mode

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

=BASE(number, radix, [min\_length])
Enter fullscreen mode Exit fullscreen mode

| Read More about BASE Function |
| 5 | CEILING Function | Rounds a given number to the nearest specified multiple.

=CEILING(number, significance)
Enter fullscreen mode Exit fullscreen mode

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

=CEILING.MATH(number, [significance], [mode])
Enter fullscreen mode Exit fullscreen mode

| Read More about CEILING.MATH Function |
| 7 | CEILING.PRECISE Function | Rounds a number to the given multiple.

=CEILING.PRECISE(number, [significance])
Enter fullscreen mode Exit fullscreen mode

| Read More about CEILING.PRECISE Function |
| 8 | DECIMAL Function (2013) | Converts an alpha-numeric number into a decimal value.

=DECIMAL(number, radix)
Enter fullscreen mode Exit fullscreen mode

| Read More about DECIMAL Function |
| 9 | EVEN Function | Returns the even integer after rounding a given number up.

=EVEN(number)
Enter fullscreen mode Exit fullscreen mode

| Read More about EVEN Function |
| 10 | EXP Function | Returns the value of a constant e raised to a number.

=EXP(number)
Enter fullscreen mode Exit fullscreen mode

| Read More about EXP Function |
| 11 | FACT Function | Returns the factorial of a given number.

=FACT(number)
Enter fullscreen mode Exit fullscreen mode

| Read More about FACT Function |
| 12 | FACTDOUBLE Function | Returns the double factorial of a given number.

=FACTDOUBLE(number)
Enter fullscreen mode Exit fullscreen mode

| Read More about FACTDOUBLE Function |
| 13 | FLOOR Function | Rounds a number down to the nearest multiple of significance.

=FLOOR(number, significance)
Enter fullscreen mode Exit fullscreen mode

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

=FLOOR.MATH(number, [significance], [mode])
Enter fullscreen mode Exit fullscreen mode

| Read More about FLOOR.MATH Function |
| 15 | FLOOR.PRECISE Function | Rounds a given number to the specified multiple.

=FLOOR.PRECISE(number, [significance])
Enter fullscreen mode Exit fullscreen mode

| Read More about FLOOR.PRECISE Function |
| 16 | GCD Function | Returns the greatest common divisor of two or more integers.

=GCD(number1, [number2],…)
Enter fullscreen mode Exit fullscreen mode

| Read More about GCD Function |
| 17 | INT Function | Rounds a given integer number down to the nearest integer.

=INT(number)
Enter fullscreen mode Exit fullscreen mode

| Read More about INT Function |
| 18 | LCM Function | Returns the least common multiple of the given integer value.

=LCM(number1, [number2],…)
Enter fullscreen mode Exit fullscreen mode

| Read More about LCM Function |
| 19 | LN Function | Returns the natural logarithm of a number.

=LN(number)
Enter fullscreen mode Exit fullscreen mode

| Read More about LN Function |
| 20 | LOG Function | Returns the logarithm of a given number using the specified base.

=LOG(number,[base])
Enter fullscreen mode Exit fullscreen mode

| Read More about LOG Function |
| 21 | LOG10 Function | Returns the base10 logarithm of a given number.

=LOG10(number)
Enter fullscreen mode Exit fullscreen mode

| Read More about LOG10 Function |
| 22 | MDETERM Function | Returns the matrix determinant of a given array.

=MDETERM(array)
Enter fullscreen mode Exit fullscreen mode

| Read More about MDETERM Function |
| 23 | MINVERSE Function | Returns the inverse matrix of the given array.

=MINVERSE(array)
Enter fullscreen mode Exit fullscreen mode

| Read More about MINVERSE Function |
| 24 | MOD Function | Returns the remainder of the two numbers after division.

=MOD(number, divisor)
Enter fullscreen mode Exit fullscreen mode

| Read More about MOD Function |
| 25 | MROUND Function | Returns a number rounded to the given multiple.

=MROUND(number, significance)
Enter fullscreen mode Exit fullscreen mode

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

=MUNIT(dimension))
Enter fullscreen mode Exit fullscreen mode

| Read More about MUNIT Function |
| 27 | ODD Function | Rounds a number to the nearest odd integer.

=ODD(number)
Enter fullscreen mode Exit fullscreen mode

| Read More about ODD Function |
| 28 | PI Function | Returns the value of the constant π (3.14159265358979).

=PI()
Enter fullscreen mode Exit fullscreen mode

| Read More about PI Function |
| 29 | POWER Function | Returns a number that is raised to a given power.

=POWER(number, power)
Enter fullscreen mode Exit fullscreen mode

| Read More about POWER Function |
| 30 | PRODUCT Function | Returns the product of all the given input numbers.

=PRODUCT(number1, [number2], …)
Enter fullscreen mode Exit fullscreen mode

| Read More about PRODUCT Function |
| 31 | QUOTIENT Function | Returns the integer portion of a division without the remainder.

=QUOTIENT(numerator, denominator)
Enter fullscreen mode Exit fullscreen mode

| Read More about QUOTIENT Function |
| 32 | RAND Function | Returns the random number between 0 and 1.

=RAND()
Enter fullscreen mode Exit fullscreen mode

| Read More about RAND Function |
| 33 | RANDBETWEEN Function | Returns the random integer number between the two specified values.

=RANDBETWEEN(bottom, top)
Enter fullscreen mode Exit fullscreen mode

| Read More about RANDBETWEEN Function |
| 34 | ROMAN Function | Converts a number to a Roman numeral as text.

=ROMAN(number, [form])
Enter fullscreen mode Exit fullscreen mode

| Read More about ROMAN Function |
| 35 | ROUND Function | Rounds a number to the specified number of digits.

=ROUND(number, num\_digits)
Enter fullscreen mode Exit fullscreen mode

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

=ROUNDDOWN(number, num\_digits)
Enter fullscreen mode Exit fullscreen mode

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

=ROUNDUP(number, num\_digits)
Enter fullscreen mode Exit fullscreen mode

| Read More about ROUNDUP Function |
| 38 | SIGN Function | Returns the sign of the given number.

=SIGN(number)
Enter fullscreen mode Exit fullscreen mode

| Read More about SIGN Function |
| 39 | SQRT Function | Returns the square root of a positive integer.

=SQRT(number)
Enter fullscreen mode Exit fullscreen mode

| Read More about SQRT Function |
| 40 | SUBTOTAL Function | Returns an aggregate result in a list or database.

=SUBTOTAL(function\_num, ref1, [ref2],...)
Enter fullscreen mode Exit fullscreen mode

| Read More about SUBTOTAL Function |
| 41 | SUM Function | Adds values in the cells

=SUM(Number\_1,Number\_2,.....,Number\_255)
Enter fullscreen mode Exit fullscreen mode

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

=IMPRODUCT(inumber, [inumber2],…)
Enter fullscreen mode Exit fullscreen mode

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

=IMREAL(inumber)
Enter fullscreen mode Exit fullscreen mode

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

=SUMPRODUCT(array1, [array2], [array3], ...)
Enter fullscreen mode Exit fullscreen mode

| Read More about SUMPRODUCT Function |
| 45 | TRUNC Function | Returns a truncated number of a given value.

=TRUNC(number, [num\_digits])
Enter fullscreen mode Exit fullscreen mode

| Read More about TRUNC Function |

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!!

Top comments (0)

Read next

wardsparadox profile image

Marking macOS component packages available based on hardware platform type

Zack McCauley -

rajessh_kumar profile image

Functional and Non-functional testing

Rajessh Kumar Ramakrishnan -

emmanuelj profile image

Exploring Python's asyncio for Asynchronous Programming

Emmanuel Joseph -

alexander-nenashev profile image

Conditional wrap component in Vue 3 pt.3

Alexander Nenashev -