Most Useful 21 Math and Trigonometry Functions in Excel
The math and trigonometry functions are one of the most used functions in Microsoft Excel. In this article, I will discuss the most useful 21 math and trigonometry functions in Microsoft Excel.
A List of Most Useful 21 Math and Trigonometry Functions in Excel
1. SUM Function
The SUM function in Excel returns the summation of the given values inside the function. It accepts numbers, ranges, cell references, or a combination of any of the three.
Syntax
=SUM(number1,[number2],...)
2. SUMIF Function
The SUMIF function in Excel calculates the sum of the values based on a single condition.
Syntax
=SUMIF(range, criteria, [sum_range])
3. SUMIFS Function
The SUMIFS function in Excel calculates the sum of the values based on multiple conditions.
Syntax
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
4. SUMPRODUCT Function
The SUMPRODUCT function in Excel first calculates the multiplication of the first two values. Then it sums up all the multiplications.
Syntax
=SUMPRODUCT(array1, [array2], [array3], ...)
5. ABS Function
The ABS function in Excel removes the sign from a number. It calculates the absolute value of any given number.
Syntax
=ABS(number)
6. BASE Function
The BASE function in Excel converts a number of a certain base into a text version of another base.
Syntax
=BASE(Number, Radix, [Min_length])
7. CEILING Function
The CEILING function in Excel is used to round up a numerical value to the nearest integer or the nearest multiple of significance.
Syntax
=CEILING(number, significance)
8. COS Function
The COS function in Excel calculates the cosine of an angle. The unit of the angle must be in radians.
If you have angles in degrees, multiply the angle with PI()/180 to convert it into degrees. Alternatively, you can use the RADIAN function to turn angles in degrees to angles in radians.
Syntax
=COS(number)
9. FLOOR Function
The FLOOR function in Excel is used to round down a numerical value to the nearest multiple of significance.
Syntax
=FLOOR(number, significance)
10. INT Function
The INT function in Excel rounds down a numerical value to the nearest integer number. It removes the fraction part of a decimal fraction number. Thus, the output becomes a rounded-down version of the input number.
Syntax
=INT(number)
11. MOD Function
The MOD function in Excel calculates the remainder when a numerical value (dividend) is divided by another one (divisor).
Syntax
=MOD(number, divisor)
12. MROUND Function
The MROUND function in Excel rounds off a numerical value to the nearest multiple of a given number. It rounds up or down depending on the distance of the nearest multiple.
Syntax
=MROUND(number, multiple)
13. RAND Function
The RAND function in Excel generates a random positive number in the range 0 ≤ x < 1.
Syntax
=RAND()
14. RANDBETWEEN Function
The RANDBETWEEN function in Excel generates a random integer number between a top value and a bottom value.
Syntax
=RANDBETWEEN(bottom, top)
15. ROUND Function
The ROUND function in Excel is used to round off the numerical values. It can round off numbers to specific values. It can also round off the decimal fraction numbers to a specific number of places after the decimal point.
Syntax
=ROUND(number, num_digits)
16. ROUNDDOWN Function
The ROUNDDOWN function in Excel is used to round down a numerical value to a specific decimal place.
Syntax
=ROUNDDOWN(number, num_digits)
17. ROUNDUP Function
The ROUNDUP function in Excel is used to round up a numerical value to a specific decimal place.
Syntax
=ROUNDUP(number, num_digits)
18. SIN Function
The SIN function in Excel calculates the sine of an angle. The unit of the angle must be in radians.
If you have angles in degrees, multiply the angle with PI()/180 to convert it into degrees. Alternatively, you can use the RADIAN function to turn angles in degrees to angles in radians.
Syntax
=SIN(number)
19. SQRT Function
The SQRT function in Excel calculates the positive square root of a positive input number.
Syntax
=SQRT(number)
20. TRUNC Function
The TRUNC function in Excel is used to remove specific digits from the fraction part of a number.
Syntax
=TRUNC(number, [num_digits])
21. SUBTOTAL Function
The SUBTOTAL function in Excel can calculate summation, average, count, maximum, minimum, multiplication, etc. within a specified sub-range. Its characteristics are controlled by its first argument named function_num. The value of the function_num can be either 1-11 or 101-111.
Syntax
=SUBTOTAL(function_num,ref1,[ref2],...)
Conclusion
One of the most used function categories in Microsoft Excel is the math and trigonometry function category. Here, I tried to discuss the most used 21 functions of the category. I hope, this blog will help you learn all these functions. Thanks.