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 basic math functions hyperbolic functions sinh cosh tanh csch sech coth

 

 

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

 

You can find similar Excel Questions and Answer hereunder

1) Is there a way I can round the sales figure to the nearest 500?

2) basic math functions gcd lcm mround multinomial sqrt sqrtpi

3) basic math functions asin acos atan acot

4) basic math functions round rounddown roundup sign

5) basic math functions log log10 roman trunc

6) basic math functions asinh acosh atanh acoth

7) basic math functions ceiling combin exp fact floor

8) Various important math functions in VBA (trigonometry, algebra, exponential, �)

9) How can I calculate depreciation of assets using Excel?

10) basic math functions sin cos tan csc sec cot

 

Here the previous and next chapter