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],...)

Examples of SUM Function in Excel

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])

Example of SUMIF Function in Excel

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], ...)

Example of SUMIFS Function in Excel

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], ...)

Example of SUMPRODUCT Function in Excel

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)

Examples of ABS Function in Excel

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])

Examples of BASE Function in Excel

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)

Examples of CEILING Function in Excel

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)

Examples of COS Function in Excel

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)

FLOOR Function in Microsoft Excel

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)

An Overview of INT Function in Microsoft Excel

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)

Examples of MOD Function in Excel

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)

An Overview of MROUND Function in Microsoft Excel

13. RAND Function

The RAND function in Excel generates a random positive number in the range 0 ≤ x < 1.

Syntax

=RAND()

Examples of RAND Function in Excel

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)

Examples of RANDBETWEEN Function in Excel

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)

Round Function in Excel

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)

An Overview of ROUNDDOWN Function in Excel

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)

An Overview of ROUNDUP Function in Microsoft Excel

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)

Examples of SIN Function in Excel

19. SQRT Function

The SQRT function in Excel calculates the positive square root of a positive input number.

Syntax

=SQRT(number)

Examples of SQRT Function in Excel

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])

Examples of TRUNC Function in Excel

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],...)

Examples of SUBTOTAL Function in Excel

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.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *