Buzz
Excel has now become an indispensable part of users, especially office workers. Tasks such as calculation, data sheet creation... are all performed on Excel. Excel integrates many mathematical functions, including mathematical functions in Excel 2013, trigonometric and mathematical functions...
Trigonometric and mathematical functions help you create spreadsheets to perform basic algebraic and calculus operations. Students or university students can apply these functions to quickly calculate results and check them against their paper calculations.
Compilation of Trigonometric and Mathematical Functions in Excel
Download the latest version of Excel here: Download Excel 2013
Trigonometric Functions
1. SIN Function
- Syntax of the function: SIN(number)
- Where: number is the value of the variable in the function.
- Calculates the sine of an angle measure.
2. COS Function
- Syntax of the function: COS(number)
- Where: number is the value of the variable in the function.
- Calculates the cosine of an angle measure.
3. TAN Function
- Syntax of the function: TAN(number)
- Where: number is the value of the variable in the function.
- Calculates the tangent of an angle measure.
4. ASIN Function
- Syntax of the function: ASIN(number)
- Where: number is the value of the variable in the function.
- Calculates the arcsine of an angle measure.
5. ACOS Function
- Syntax of the function: ACOS(number)
- Where: number is the value of the variable in the function.
- Calculates the arccosine of an angle measure.
6. ATAN Function
- Syntax of the function: ATAN(number)
- Where: number is the value of the variable in the function.
- Calculates the arctangent of an angle measure.
Mathematical Functions
1. ABS Function
- Syntax of the function: ABS(number)
- Where: number is the value of the variable in the function.
- Returns the absolute value of the parameter.
Example: Use the ABS function to calculate the absolute value in the following table.
Enter the formula in cell E5, you will get the result and copy it down the rows below.
2. SQRT Function
- Syntax of the function: ABS(number)
- Where: number is the value of the variable in the function.
- Calculates the square root of a number.
3. POWER Function
- Syntax of the function: ABS(number, power)
- Where: number is the base number (real number); Power is the exponent of the function.
- Calculates the power function (x raised to the power of y, where x is the first parameter and y is the second parameter).
Example: Calculate the power of Power base Number. Apply the Power function. We have the formula for cell value C6 as: =POWER(A6, B6). The result obtained will be:
Copy the formula for the remaining cells. We get the final result:
4. SUM Function
- Syntax of the function: SUM(number1, number2,…)
- Where: number1, number2, … are the values of the variables in the function.
- Calculates the sum of values in specified cells in Excel.
5. ROUND Function
- Syntax of the function: ROUND(number, num_digits)
- Where: number is the number you want to round; num_digits is the number of digits to which you want to round the number.
- Rounds a decimal number to n digits after the decimal point (n is the second parameter in the function)
Example: Use the ROUND function to round the average score column for the student list below:
6. PI Function
- Syntax of the function: PI()
- Function returns the value of PI (3.1415…):
Leaving the parentheses empty is the same as entering the value 1, meaning it returns the value of PI. If you input a number n inside the parentheses, it returns the value PI*n.
7. EXP Function
- Syntax of the function: EXP(number)
- Where: number is the exponent applied to the base e.
- Returns the power of e raised to a certain exponent
8. QUOTIENT Function
- Syntax of the function: QUOTIENT(numerator, denominator)
- Where: numerator is the dividend. Denominator is the divisor.
- Returns the integer portion of the division of two numbers:
9. MOD Function
- Syntax of the function: MOD(number, divisor)
- Where: number is the number you want to find the remainder of; divisor is the number you want to divide the number by.
- Returns the remainder of the division of two numbers
10. LOG Function
- Syntax of the function: LOG(number, [base])
- Where: number is a positive real number you want to calculate the logarithm of; base is the Base of the logarithm (If base is omitted, it is assumed to be 10).
- Returns the logarithm of a number to a specified base
11. LOG10 Function
- Syntax of the function: LOG10(number)
- Where: number is a positive real number you want to calculate the logarithm base 10 of.
- Calculates the logarithm base 10 of a number
12. LN Function
- Syntax of the function: LN(number)
- Where: number is a positive real number you want to calculate the natural logarithm of.
- Returns the natural logarithm of a number. Natural logarithm is based on the constant e (2.71828182845904).
13. LCM Function
- Syntax of the function: LCM(number1, [number2], ...)
- Where: Number1 is mandatory, the subsequent numbers are optional from 1 to 255 values you want to find the least common multiple of. If a value is not an integer, it is truncated.
- Returns the least common multiple of integers.
14. FACT Function
- Syntax of the function: FACT(number)
- Where: number is a non-negative number you want to find the factorial of. If the number is not an integer, it is truncated.
- Calculates the factorial of a number.
15. INT Function
- Syntax of the function: INT(number)
- Where: number is a real number you want to round down to an integer.
- Rounds down to the nearest integer value:
16. EVEN Function
- Syntax of the function: EVEN(number)
- Where: number is the value to be rounded.
- Rounds up to the nearest even integer value
Now you know the most common trigonometric and mathematical functions in Excel. These are the most popular functions in algebra and calculus calculations. Apply them to create your calculations for the quickest and most accurate results.
