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

Table of Contents

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

**can be either**

*function_num***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.