Trigonometric functions in Excel
Excel supports simple and easy trigonometric calculations for users. Especially in difficult problems, this tool helps a lot. The following article introduces you to trigonometric functions that Excel supports.
1. Ham Sin
- Syntax: Sin (number).
Where: number is the value of the angle of the angle Sin.
- Meaning: Returns the Sin value of 1 angle, the value is in the range from -1 to +1.
- For example:
You pay attention to work with trigonometric functions in Excel unit of measurement is radians.
Step 1: Convert the unit of measurement to radians. Insert 1 more column and enter the command as shown:
Step 2: Drag formatting to the remaining cells. Enter the formula for calculating the Sin value as shown below:
Finally, you drag the formatting to the remaining cells with the following result:
2. Ham Cos
- Syntax: Cos (number) .
Where: number is the value of the degree of angle to calculate Cos.
- Meaning: Returns the Cos value of 1 angle, the value is in the range from -1 to +1.
- For example:
Step 1: You enter the formula as shown.
Step 2: Drag the format to the remaining cells with the results as shown below:
3. Ham Tan
- Syntax: Tan (number) .
In which: number is the value of the degree of the angle to be calculated.
- Meaning: Returns the Tan value of 1 angle, the value is between -1 and +1.
- For example:
4. Asin function
- Syntax: Asin (number) .
Where :: number is the value of the angle to calculate Asin.
- Meaning: Returns the Asin value of 1 corner, the value is in the range of -1 to +1.
- For example:
5. Asinh function
- Syntax: Asinh (number) .
Where: number is the value of the angle to calculate Asin.
- Meaning: Returns an Asinh value of an angle but this value is radian.
- For example:
6. The Acos function
- Syntax: Acos (number) .
Where: number is the value of the angle to calculate Acos.
- Meaning: Returns the Acos value of 1 angle, the value is in the range of -1 to +1.
- For example:
7. Acosh function
- Syntax: Asinh (number) .
Where: number is the value of the angle to be calculated.
- Meaning: Returns an Acosh value of an angle but this value is radian.
- For example:
8. Ham Atan
- Syntax: Atan (number) .
In which: number is the value to be calculated Atan.
- Meaning: Returns an Atan value of an angle.
- For example:
9. Ham Atan2
- Syntax: Antan2 (x_num, y_num) .
Where: x_num, y_num are values of degrees and degrees. -
Meaning: Returns the Radian value within the range from - Pi-> + Pi.
- For example:
10. Ham Atanh
- Syntax: Atanh (number) .
In which: number is the value to calculate Atanh.
- Meaning: Returns the value of Radian.
- For example:
11. The Degrees function
- Syntax: Degrees (angle) .
Where: angle is the value of the degree of an angle to be converted.
- Meaning: Convert the measurement of an angle from units of radians to degrees.
- For example:
12. Ham Radians
- Syntax: Radians (angle) .
Where: angle is the value of the degree of an angle to be converted.
- Meaning: Convert the measurement of an angle from degrees to radians.
- For example:
Good luck!
You should read it
- How to add computers to 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
- Summary of information functions in Excel
- Synthesis and function of functions in mathematical and trigonometric functions
- Comparison functions in Excel - How to use comparison functions and examples using comparison functions
- Date time functions in Excel
May be interested
- 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.
- Instructions for using Index function in Excelindex is a function that returns an array in excel. when using the index function, you get the values in a cell between the column and the row.
- Tips for working with functions in Excelfunctions that work with excel functions functions are predefined formulas for performing specific calculations, or for manipulating spreadsheets.
- PI (PI Function) in Excel - How to use PI numbers in Excelpi (pi function) in excel - how to use pi numbers in excel. pi number is a mathematical constant with an approximate value of 3,1415926535897 ... we can find pi numbers in many trigonometric and geometric formulas. especially the formulas related to circles, ellipses, and spheres:
- The MIN and MAX functions (the smallest and largest value functions) in Excelthe function to return the maximum value (max) and the function to return the minimum value (min) are two common statistical functions used by a lot of people in the process of manipulating and processing data in excel.
- Common Excel functions you need to know about accountingmastering the common excel functions helps accountants save time and effort compared to conventional manual calculations. today, software tips will list and guide readers on how to use some functions commonly used in accounting.