Related Functions:

The IMCSCH function returns the hyperbolic cosecant of a complex number in x+yi or x+yj text format.

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

Syntax

=IMCSCH(inumber)

Arguments

Argument Description
inumber A complex number for which you want the hyperbolic cosecant

Note: Use the COMPLEX function to convert real and imaginary coefficients into a complex number.

Examples

  A B C D
1 Data Formula Result Notes
2 3+4i =IMCSCH(A2) -0.0648774713706355+0.0754898329158637i Returns the hyperbolic cosecant of a complex number 3+4i
3   =IMCSCH(“3+4i”) -0.0648774713706355+0.0754898329158637i  
4   =IMCSCH(“2-i”) 0.141363021612408+0.228375065599687i  
5   =IMCSCH(COMPLEX(4,1)) 0.0197797995721927-0.0308258875766998i  

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the supplied inumber argument is a logical value
#NUM! Occurs if the supplied inumber argument is not recognized as a complex number

The hyperbolic cosecant of a complex number is defined as the inverse of the hyperbolic sine and is calculated as:    

    \[  csch(z) = \frac{1}{sinh(z)}  \]

See Wikipedia for more information on complex numbers.