Related Functions:

The CSCH function returns the hyperbolic cosecant of an angle specified in radians.

  • This function was introduced in Excel 2013 and so is not available in earlier versions.

Syntax

=CSCH(number)

Arguments

Argument Description
number The angle, in radians, that you want to calculate the hyperbolic cosecant of

  The absolute value of number must be less than 2^27

Examples

  A B C
1 Formula Result Notes
2 =CSCH(1.5) 0.4696 Returns the hyperbolic cosecant of 1.5
3 =CSCH(RADIANS(45)) 1.151183871 Returns the hyperbolic cosecant of a 45 degree angle

Note: If the angle is in degrees, you need to be convert it to radians before supplying it to the CSCH function. You can convert it, using the RADIANS function: =RADIANS(degrees)

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the supplied number argument is not a numeric value
#NUM! Occurs if the supplied number argument is less than -2^27 or is greater than 2^27
#DIV/0! Occurs if the supplied number argument is equal to zero

The hyperbolic secant si the reciprocal of the hyperbolic sine. Therefore, the hyperbolic cosecant is calculated as:   

    \[   csch(x) = \frac 1{sinh(x)} = \frac 2{(e^x - e^{-x})}    \]

See Wikipedia for more information on hyperbolic functions.