Purpose
Get hyperbolic cosecant of complex number
Return value
The hyperbolic cosecant of the complex number.
Syntax
=IMCSCH(complex_num)- complex_num - The complex number in the form "x+yi".
How to use
The Excel IMCSCH function returns the hyperbolic cosecant of a complex number. Given "1+1.5707963267949i" as input, the function returns "-1.72324E-15-0.648054274i" as output.
=IMCSC(COMPLEX(1, PI()/2)) // returns -1.72324E-15-0.648054274i
Explanation
The complex hyperbolic cosecant function is the reciprocal of the complex sine function.
In Excel, the function's output is equivalent to the following formula.
=IMDIV(1,IMSINH(z)) // equivalent to IMCSCH(z)
Related functions
COMPLEX Function
The Excel COMPLEX function creates a complex number with given real and imaginary coefficients. COMPLEX returns a text result in the form x + yi or x + yj....
CSC Function
The Excel CSC function returns the cosecant of an angle provided in radians.
CSCH Function
The Excel CSCH function returns the hyperbolic cosecant of an angle.
