# 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.