Summary of trigonometric functions in Excel
In addition to the familiar data calculation functions, Excel also provides users with arithmetic functions, such as trigonometric functions such as RADIANS, DEGREES, COS functions .
Excel is now in addition to displaying statistics and comparisons, but it is also possible to calculate normal math, such as calculating trigonometry. These trigonometric functions are responsible for helping users quickly calculate calculations, instead of manually calculating as before.
The following article will guide readers to use the trigonometric functions in Excel from basic to advanced.
- How to combine Sumif and Vlookup functions in Excel
- 3 ways to calculate totals in Excel
- How to use SUMPRODUCT function in Excel
Trigonometric functions on Excel
1. Function RADIANS
RADIANS (angle) function syntax. In it, Angel is a measure of an angle in degrees to Radian. The RADIANS function will be used to convert the measurement of an angle from degrees to radians.
We will calculate the angle measurement of 1 45 degree angle as shown below.
2. Function DEGREES
Syntax of DEGREES (angle) function . This function is used to convert radian values to angles. In which Angel is the angle value in radians that want to convert to degrees.
3. COS function
The function syntax is COS (number ). This function will calculate the radian value, which is the cosine of a number. In which Number will be the angle value in Radian.
4. COSH function
Function syntax is COSH (number) . The function will return the radian value, which is the hyperbolic cosine value of a number. Where Number is the angle value calculated in radians you want to calculate.
5. SIN function
The function syntax is SIN (number) . The function will result in the radian value of some sine. Number is the angle value in radian.
6. Ham Sinh
Function syntax is BIRTH (number) . The BIRTH function will return a radian value, which is the hyperbolic sine of a number. Number is the angle value in radian.
7. Ham TAN
Function syntax is TAN (number) . The function returns the radian value of tangent of a number. Number is the angle value in radians.
8. Ham TANH
The function syntax is TANH (number) . The function returns a radian value which is the hyperbolic tangent of a number. Number will be the angle value in radians you want to calculate.
9. ACOS function
Function syntax is ACOS (number) . The function used to get the result is the radian value between 0 and Pi, arccosine, or the cosine inverse of a number between -1 and 1.
Number is still the angle value in radian.
10. ACOSH function
The function syntax is ACOSH (number) . The function returns the radian value, inverse the hyperbolic cosine of a number greater than or equal to 1. Number is the angle value in radians.
11. ASIN function
Function syntax is ASIN (number) . The function returns the radian value between -Pi / 2 to Pi / 2, arcsine, or the sine inverse of a number between -1 and 1. Number is also a value in radians.
12. Ham ASINH
ASINH (number) function syntax. The function will return the radian value, inverse the hyperbolic sine of a number. Number is the radian value.
13. Ham ATAN
Syntax of ATAN (number) function . The function returns the radian value between -Pi / 2 and Pi / 2, which is the arctang or tangent of a number.
14. ATAN2 function
- Syntax function ATAN2 (x_num, y_num) .
- Where x_num, y_num are 2 values of 2 angles in radians you want to calculate.
- The function will return the radian value in the range (but not included) from -Pi to Pi, the arctang, or the inverse tang of a point with x and y coordinates.
15. Ham ATANH
ATANH (number) function syntax. The function returns the radian value of the tang-hyperbolic inverse of a number in the range from -1 to 1. Number still calculates the radian value.
With the above trigonometric functions, users can easily calculate on Excel, with trigonometric problems. Just grasp the correct syntax and calculate the right radian value of a certain angle.
Refer:
- How to use Excel's VALUE function
- How to use the Match function in Excel
- These are the most basic functions in Excel that you need to understand
You should read it
- How to graph trigonometric functions with Excel
- How to fix the SUM function doesn't add up in Excel
- Complete financial functions in Excel you should know
- MS Excel - Lesson 5: Excel formulas and functions
- Date time functions in Excel
- Summary of information functions in Excel
- Common calculation functions in Excel
- The 10 most useful but often forgotten functions in excel
May be interested
- MS Excel - Lesson 5: Excel formulas and functionsthe formula in excel is a program that performs calculations on data tables. these formulas perform very precise operations such as adding, multiplying, or comparing values in worksheets.
- Synthesis and function of functions in mathematical and trigonometric functionssynthesis and function of functions in mathematical and trigonometric functions
- 8 little-known Excel functions that can save you a lot of workeven seasoned excel users often find themselves stuck performing tasks manually that could be automated with a few clever functions.
- Common math functions in Excelsummary of common calculation functions in excel for accountants.
- Comparison functions in Excel - How to use comparison functions and examples using comparison functionscomparison functions in excel - how to use comparison functions and examples using comparison functions with a large amount of data, you want to check for duplicates by checking normally, it is really hard. in this article, introduce to you the functions
- Date time functions in Excelexcel supports you to process and calculate quickly with the functions that excel provides such as calculation functions, date functions ... one of them is the function of time to help you handle the prices. time value: hour, minute, second conveniently
- 10 EXCEL functions that ACCOUNTERS often usein excel, there are many functions that can help accounting in daily data entry, but here are some common functions used by accounting.
- The 10 most useful but often forgotten functions in excelmicrosoft excel is an extremely effective and effective calculation tool not only for accounting and office but also for many other industries.
- Logical functions (logical) in Excellogical functions are used a lot during data processing in excel. the article summarizes the syntax and functions of functions in logical function groups in excel.
- How to use Excel's VALUE functionexcel's value function will convert a string to a digital form, which can be combined with other functions such as left function, right function, mid function.