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.

    Picture 1 of Summary of trigonometric functions in Excel

    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.

    Picture 2 of Summary of trigonometric functions in Excel

    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.

    Picture 3 of Summary of trigonometric functions in Excel

    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.

    Picture 4 of Summary of trigonometric functions in Excel

    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.

    Picture 5 of Summary of trigonometric functions in Excel

    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.

    Picture 6 of Summary of trigonometric functions in Excel

    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.

    Picture 7 of Summary of trigonometric functions in Excel

    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.

    Picture 8 of Summary of trigonometric functions in Excel

    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.

    Picture 9 of Summary of trigonometric functions in Excel

    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.

    Picture 10 of Summary of trigonometric functions in Excel

    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.

    Picture 11 of Summary of trigonometric functions in Excel

    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.

    Picture 12 of Summary of trigonometric functions in Excel

    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.

    Picture 13 of Summary of trigonometric functions in Excel

    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.
  • Picture 14 of Summary of trigonometric functions in Excel

    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.

    Picture 15 of Summary of trigonometric functions in Excel

    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
  • ncG1vNJzZmismaXArq3KnmWcp51kwLa5zJqpsmWfm3q1vsigpqennZrBs7XCZp2uppOptrC60magp2WVrbCmuA%3D%3D