Excel math hyperbolic functions: sinh, cosh, tanh, csch, sech, coth
Excel Function HYPERBOLIC FUNCTIONS
A hyperbolic function is a one which specifies the relationship between two distances; one from origin to a
point on the hyperbola and other from coordinate axes to the same point on the hyperbola.
The main difference between normal trigonometric functions and hyperbolic functions is that, the hyperbolic functions
form half a circle instead of full circle.
Excel Function SINH
The SINH() function is used to determine the hyperbolic sine value of the number specified.
This function takes single argument which is the angle expressed as number.
The angle is always in radian
If you want to use degree transform the angle before with =RADIANS(angle in degree)
Angle(deg) | Angle (Rad) | Formula | SINH() |
0 | 0 | =SINH(M10) | 0 |
30 | 0.523598775598299 | =SINH(M11) | 0.54785347388804 |
90 | 1.5707963267949 | =SINH(M12) | 2.30129890230729 |
180 | 3.14159265358979 | =SINH(M13) | 11.5487393572577 |
360 | 6.28318530717959 | =SINH(M14) | 267.744894041016 |
Excel Function COSH
The COSH() function is used to determine the hyperbolic cosine value of the number specified.
This function takes single argument which is the angle expressed as number.
The angle is always in radian
If you want to use degree transform the angle before with =RADIANS(angle in degree)
Angle(deg) | Angle (Rad) | Formula | COSH() |
0 | 0 | =COSH(M23) | 1 |
30 | 0.523598775598299 | =COSH(M24) | 1.14023832107643 |
90 | 1.5707963267949 | =COSH(M25) | 2.50917847865806 |
180 | 3.14159265358979 | =COSH(M26) | 11.5919532755215 |
360 | 6.28318530717959 | =COSH(M27) | 267.746761483748 |
Excel Function TANH()
The TANH() function is used to determine the hyperbolic tangent value of the number specified.
This function takes single argument which is the angle expressed as number.
The angle is always in radian
If you want to use degree transform the angle before with =RADIANS(angle in degree)
Angle(deg) | Angle (Rad) | Formula | TANH() |
0 | 0 | =TANH(M36) | 0 |
30 | 0.523598775598299 | =TANH(M37) | 0.480472778156452 |
90 | 1.5707963267949 | =TANH(M38) | 0.917152335667274 |
180 | 3.14159265358979 | =TANH(M39) | 0.99627207622075 |
360 | 6.28318530717959 | =TANH(M40) | 0.999993025339611 |
Excel Function CSCH()
The CSCH() function is used to determine the hyperbolic cosine of the number specified.
This function takes single argument which is the angle expressed as number.
The angle is always in radian
If you want to use degree transform the angle before with =RADIANS(angle in degree)
Angle(deg) | Angle (Rad) | Formula | CSCH() |
10 | 0.174532925199433 | =CSCH(M49) | 5.70059217731439 |
30 | 0.523598775598299 | =CSCH(M50) | 1.82530557468795 |
90 | 1.5707963267949 | =CSCH(M51) | 0.434537208094696 |
180 | 3.14159265358979 | =CSCH(M52) | 8.65895375300469E-02 |
360 | 6.28318530717959 | =CSCH(M53) | 3.73489848828567E-03 |
Excel Function SECH
The SECH() function is used to determine the hyperbolic secant of the number specified.
This function takes single argument which is the angle expressed as number.
The angle is always in radian
If you want to use degree transform the angle before with =RADIANS(angle in degree)
Angle(deg) | Angle (Rad) | Formula | SECH() |
10 | 0.174532925199433 | =SECH(M62) | 0.984960079661621 |
30 | 0.523598775598299 | =SECH(M63) | 0.877009640454779 |
90 | 1.5707963267949 | =SECH(M64) | 0.398536815338387 |
180 | 3.14159265358979 | =SECH(M65) | 8.62667383340544E-02 |
360 | 6.28318530717959 | =SECH(M66) | 3.73487243863713E-03 |
Excel Function COTH
The COTH() function is used to determine the hyperbolic cotangent of the number specified.
This function takes single argument which is the angle expressed as number.
The angle is always in radian
If you want to use degree transform the angle before with =RADIANS(angle in degree)
Angle(deg) | Angle (Rad) | Formula | COTH() |
10 | 0.174532925199433 | =COTH(M75) | 5.78763778860236 |
30 | 0.523598775598299 | =COTH(M76) | 2.08128336393364 |
90 | 1.5707963267949 | =COTH(M77) | 1.09033141072737 |
180 | 3.14159265358979 | =COTH(M78) | 1.00374187319732 |
360 | 6.28318530717959 | =COTH(M79) | 1.00000697470904 |